What Should We Index?

• Any column frequently used in retrieval

• primary key columns

• columns that are often queried in a sorted order

• columns that are used in joins

• columns that are often searched for ranges

Previous slide

Next slide

Back to first slide

View graphic version