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
  • PrintPrint
Share this Page URL
Help

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.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint