SQL Server Performance

Identify bookmark lookups in SQL 2005 in XML Plan

Discussion in 'SQL Server 2005 T-SQL Performance Tuning' started by Aston, Apr 14, 2008.

  1. Aston New Member

    Hi ,
    In SQL Server 2005, in the execution plan instead of showing bookmark lookups its says ClusteredIndex Seek if the table has clustered index.
    From XML Plan How can we determine that this clustered index seek is due to bookmark lookup from another non clustered index ?
    Thanks !!
  2. jagblue New Member

Share This Page