In Oracle, Tom Kyte's advice is to never rebuild them, unless there are reasons for structural change or physically relocating the storage. I have occasionally

In Oracle, Tom Kyte's advice is to never rebuild them, unless there are reasons for structural change or physically relocating the storage. I have occasionally seen performance gains by rebuilding a composite index with key compression, for example. Indexes do tend to return to their natural size in heavy use, so repeatedly shrinking them will just tax performance for a temporary gain in storage. https://asktom.oracle.com/pls/apex/f?p=100:11:::::P11_QUESTION_ID:2913600659112 https://asktom.oracle.com/pls/apex/f?p=100:11:::::P11_QUESTI...