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.
The xCapture and xtop eBPF tools are now in beta, with a demo dataset
-
The title says it all, I think it’s time to call the xcapture and xtop
toolset a beta version now. There are plenty of bugs, issues and
shortcomings to fix...
Acum o săptămână
Niciun comentariu:
Trimiteți un comentariu