January 2019
Intermediate to advanced
286 pages
7h 41m
English
If most records can be removed using an INDEX, the index will be the most effective way. If you cannot eliminate many of these records, the performance results between the index and the data in your table might be more expensive than using an index, and the solution would simply be to use a FULL SCAN. A good practice of the 20% use of the data seems to be the best value whether we use an index or not.
Read now
Unlock full access