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
  2. preethi Member

    is it possible to get the execution plan?
  3. satya Moderator

    Just for sake of testing can you drop and recreate the clustered index if the rowcount is not that big.

Share This Page