Index Scans:Upper and Lower Index Filters
Create indexes on columns that are the most selective.
For example:
SELECT * FROM CUSTOMER
WHERE ACCOUNT BETWEEN 100 and 1000
AND STATUS = “A”
AND STATE = “MD”
Which column is the most selective? Account, status or state?
Previous slide
Next slide
Back to first slide
View graphic version