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