Optimizing single-table queries
Consider all possible plans
Combine index scans
Index Scan
- An Index Scan retrieves index rows from an index.
- The index row contains a row id, identifying the row in the heap.
- After each index row is retrieved, the row id is used to retrieve the
table row from the heap.
|