Post reply

SQL Query Tuning help

  • July 8, 2012 at 12:24 pm

    #1510116

    Attached is the execution plan AND object definition....

  • July 8, 2012 at 12:44 pm

    #1510121

    ashok23_sharma (7/8/2012)

    Attached is the execution plan AND object definition....

    Looks like the execution plan is the estimated plan. What is needed is the actual execution plan when the query is run.

  • July 8, 2012 at 12:59 pm

    #1510123

    Well that's definitely not optimal... Why does the table not have a clustered index? Why is the index on EventID a unique nonclustered index rather than a primary key (backed by a clustered index)?

    Consider an index on DAuditNew (SubType, AuditID) Include (ValueKey, Value1)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply