First page Back Continue Last page Graphics

Clustering Factor Example

Notes:

To test the clustering factor, update statistics and query the USER_INDEXES view. The closer the clustering factor is to the number of rows, the less clustered it is.
We can create a clustered table by creating with CTAS and an ORDER BY in the subquery, as shown.
See the supplied script poorly_clustered_data.sql for a working example of this demonstration.