|< < 11 > >|

Optimizing single-table queries

Consider all possible plans

Combine index scans

The essential difference between Index Scan and Bitmap Index Scan

After the Bitmap Index Scan, the pages can be read

• Avoiding rereads of the same page.
• In order, possibly trading random access for sequential access.

Or hold on to the list of page references for later processing.

|< < 11 > >|