Optimizing single-table queries
Consider all possible plans
Combine index scans
- If there are (separate) indexes on a and b, most database
systems will consider using both and combining the results. (MySQL will not.)
- SelectIndex on a.
- SelectIndex on b.
- Intersect the results.
- Retrieve qualifying rows.
|