SQL Server Performance

how to tune this query,help me

Discussion in 'Performance Tuning for DBAs' started by Raja.V, Dec 17, 2007.

  1. Raja.V New Member

    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
  2. zigzag219 New Member

Share This Page