|< < 5 > >|

Optimizing single-table queries

Consider all possible plans

Index on (a, b) or (b, a)

• If there is a multi-column index, it can be used.
• SelectIndex on the entire predicate.

|< < 5 > >|