updates affecting indexes

[jepatte]

I have puzzled by this for a week now. I have one SQL database that has been doing great. I have a table that has 4 indexes on it and the speed is top notch.

In a completely separate database on this server, I have been doing mass updates. ie. UPDATE t1 SET f2 = 'Y' WHERE f2 = 'X' etc. These updates have been takigna while. When they are done though, the indexes in the table above I mentioned in a separate database slow to a crawl.

Then I have to reindex them, and now they are fine again. Why would me updating one database table affect an index in a different database table. Again, I can see speed slowing down DURING the update, but after its done, the speed is still crawling.

 

[ptheriault]

Try updating statistics after your update.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[jepatte]

how do you update statistics?

 

[jepatte]

nevermind I see how to update stats, but I cant afford to do this to all tables everytime I update a different table. This is crazy?