Oracle how often should indexes be rebuilt

You need to reorganize to reclaim white space. Generally rebuild index when the clustering factor exceeds eight times the number of dirty blocks in the base. 30 de out. de Oracle provides a fast index rebuild capability that allows you to re-create an index without having to drop the existing index. 10 de dez. de @APC Frequent changes to tables in the database require index rebuilds, it is a routine to help tune performance. And routines often get.