http://richardfoote.wordpress.com/2012/12/19/storage-indexes-vs-database-indexes-part-ii-clustering-factor-fast-track/
The Clustering Factor (CF) is the most important index related statistic, with the efficiency of an index performing multi-row range scans very much dependent on the CF of the index. If the data in the table is relatively well clustered in relation to the index (i.e. it has a “low” CF), then an index range scan can visit relatively few table blocks to obtain the necessary data. If the data is effectively randomised and not well clustered in relation to the index (i.e. has a “high” CF), then an index range scan has to visit many more table blocks and not be as efficient/effective as a result. The CBO will be less inclined to use such an index as a result, depending on the overall selectivity of the query.
New Training Deep Dives: Handling Oracle Optimizer, Partitioning and
I/O-Intensive Databases
-
If you want to end the year by learning something practical and new, this
is it! I am running new special-focus deep dive seminars that address two
complex...
Acum 4 zile
Niciun comentariu:
Trimiteți un comentariu