|< < 7 > >|

Optimizing single-table queries

Consider all possible plans

Combine index scans

Postgres example from a blog post:

Query:
EXPLAIN SELECT * FROM test2 WHERE major = 1 OR minor = 8;

|< < 7 > >|