Automatic Indexing . Exams of Oracle . The Clustering Factor
The Clustering Factor-Indexes
On 09/04/2022 by Robert CorvinoNext, let’s look at some of the information Oracle will use. We are specifically going to look at the CLUSTERING_FACTOR column found in the USER_INDEXES view. The Oracle Database Reference manual tells us this column has the following meaning: Indicates the amount of order of the rows in the table based on the values of