The following query when executed will involve in a bookmark look up ,how to avoid bookmark look up for this query SELECT T1.CONFLICT_ID, CONVERT (VARCHAR (10),T1.LAST_UPD, 101) + ' ' + CONVERT (VARCHAR (10),T1.LAST_UPD, 8), CONVERT (VARCHAR (10),T1.CREATED, 101) + ' ' + CONVERT (VARCHAR (10),T1.CREATED, 8), T1.LAS T1.CREATED, T1.MODIFICAT T1.ROWD, T1.STD_NIT, T2.CURCYD, T1.PRI_D, T2.SUBTYPE T1.PRI_METH T1.PRODID, T1.CONTRACTPRICE, T1.XGROUPPRICE, T1.XLIST_PRICE, T1.SVCPERMT, T1.SVC_PERCT, T1.VOL_DISID, T3.DISCNT_CD FROM dbo.S_PRILSTITEM T1 INNER JOIN dbo.SPRILST T2 ON T1.PRI_D = T2.ROWD LEFT OUTER JOIN dbo.SVOLDISCNT T3 ON T1.VOL_DISID = T3.ROWD WHERE (T1.PRI_D = '5-4-330') Thanks in advance
According to this article... http://www.sql-server-performance.com/tips/query_execution_plan_analysis_p1.aspx ...you may want to consider the following... Use a different Clustered Index Use a better covering index. Return fewer rows in the select statement. BOL isn't much help on this topic. BOL just states that a bookmark is a marker for a row in a table or a clustered index.