Home Forums SQL Server 2008 SQL Server 2008 - General Tuning expensive query III RE: Tuning expensive query III

  • May 28, 2015 at 11:10 pm

    #1801464

    You've been around enough to know about posting DLL, sample data, etc... You're also posting the estimated query plan. The actual query plan would be better.

    Anyhow, from a birds-eye view...

    That non-clustered index is obviously not helping much based on your stats. All those SELECT DISTINCTS are killing you; a sign of very bad database design. You're query plan is showing mostly Clustered Index Scans. A non-clustered index seek would probably be better. Again, due to bad data modeling and poor query design.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001