FIGURE 2: Textual Execution Plan for a Query with Clustered Indexes


StmtText 
_______________________________________________________________________ 

|--Hash Match(Inner Join, 
HASH:([order_tab].[order_no])=
([position].[order_no]), 
RESIDUAL:([position].[order_no]=[order_tab].[order_no])) 
|--Clustered Index 
Seek(OBJECT:([projects].[dbo].[order_tab].[ci_order_orderno]), 
SEEK:([order_tab].[order_no] BETWEEN 1 AND 10) ORDERED) 
|--Clustered Index 
Scan(OBJECT:([projects].[dbo].[position].[ci_pos_posno]))