1027
Chapter 45: Indexing Strategies
45
FIGURE 45-13
The index seek operator can have a seek predicate, which uses the B-tree; and a predicate,
which functions as a nonindexed fi lter.Query Path 7 — Filter by 2 x NC Indexes
A common indexing dilemma is how to index for multiple where clause criteria. Is it better
to create one composite index that includes both key columns? Or do two single key column
indexes perform better? Query Paths 7 through 9 evaluate the options.c45.indd 1027c45.indd 1027 7/31/2012 10:16:42 AM7/31/2012 10:16:42 AM
http://www.it-ebooks.info