//
you're reading...
Uncategorized

How the Clustering Factor Impacts SQL Statements in Oracle 11g | A Confio Resource

The CLUSTERING_FACTOR column in the USER_INDEXES view gives an indication as to how organized the data is compared to the indexed columns. If the value of the CLUSTERING_FACTOR column value is close to the number of leaf blocks in the index, the data is well ordered in the table. If the value is not close to the number of leaf blocks in the index, then the data in the table is not well ordered. The leaf blocks of an index store the indexed values as well as the ROWIDs to which they point.

via How the Clustering Factor Impacts SQL Statements in Oracle 11g | A Confio Resource.

Advertisements

Discussion

Comments are closed.

%d bloggers like this: