Entire Site
Free Trial
Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
Chapter 9. Tuning Table Access > Multvalue Single-Column Lookups
Multvalue Single-Column Lookups
When a query on a single table contains an OR clause on a single column (or the equivalent IN clause), it can be processed in one of the following ways:
Perform a full table scan and check each row against the selection criteria (which shows up as FILTER in the execution plan).
Perform multiple index based lookups of the table.
