FIGURE 1: Textual Execution Plan for a Query with Nonclustered Indexes


StmtText 
_______________________________________________________________________ 

|--Bookmark Lookup(BOOKMARK:([Bmk1002]), 
OBJECT:
([projects].[dbo].[position]) WITH PREFETCH) 
|--Nested Loops(Inner Join) 
|--Bookmark Lookup(BOOKMARK:([Bmk1000]), 
OBJECT:
([projects].[dbo].[order_tab]) WITH PREFETCH) 
| |--Index Seek(OBJECT:([projects].[dbo].[order_tab].[i_order_orderno]), 
SEEK:([order_tab].[order_no] BETWEEN 1 AND 10) ORDERED) 
|--Index Seek(OBJECT:([projects].[dbo].[position].[i_pos_orderno]), 
SEEK:([position].[order_no]=[order_tab].[order_no]) 
ORDERED)