Optimizing single-table queries
Consider all possible plans
Combine index scans
- : Get row from index, use row id to read row from table.
- : Accumulate addresses of table
pages during index scan. Then, read the pages and find qualifying
rows.
- Postgres uses only bitmap index scan when combining index scan results.
|