Best Tutorials website


How to measure Index Selectivity

How to measure Index Selectivity

B*TREE Indexes improve the performance of queries that select a small percentage of rows from a table. As a general guideline, we should create indexes on tables that are often queried for less than 15% of the table's rows. This value may be higher in situations where all data can be retrieved from an index, or where the indexed columns can be used for joining to other tables.




Views: 1329 | Rating star | by Donald




View this tutorial
Broken link Report broken link?