SQL Server Performance

added index/stats query plan doesnt change

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by MichaelB, Aug 4, 2008.

  1. MichaelB Member

    Guys and Gals
    I have query that takes 30 seconds in Dev/Test/Prod. I added index, updated stats to a heap. It has non-clustered but no clustered index. dont ask. It is a vernor produced app by people who dont know a thing about db design. When I added this additional non-clustered index (all that I am allowed to do) in dev and test the query went down to 4 seconds. Same on test. When I did it on prod it didnt change the plan. I did a fullscan when I updated the stats and shouldnt have to re-index the other indexes since it is a heap. The code is embedded in the app so I cant recompile a proc. I am frustrated. This scan is killing the server.
    Thanks in advance!
    Mike
    MichaelB, Aug 4, 2008
    #2

  2. preethi Member

    is it possible to get the execution plan?
    preethi, Aug 5, 2008
    #3

  3. satya Moderator

    Just for sake of testing can you drop and recreate the clustered index if the rowcount is not that big.
    satya, Aug 6, 2008
    #4

Share This Page