March 24, 2003 at 8:43 am
When I drop and re-create indexes I usually update statsistics for that table right after I'm done so that the optimizer chooses a good plan. My question is, do I need to update the stats? I have suto update stats selected on the options, shouldn't it be done automatically?
Thanks
E...
March 24, 2003 at 9:08 am
I don't think you need to update stats. I would update stats if I drop and recreate the index with differents columns for example, but if it still remains the same. I would let SQL to update them when it needs.
March 24, 2003 at 10:19 am
Yeah, that is what I thought too. But I have dropped and re created indexes thinking that the auto stats would take care of it. What happened was that stored procs that hit those tables started performing poorly. I manually updated the stats for those tables and the procs performed fine. kind of a mystery.
E...
March 24, 2003 at 11:03 am
Why not do a Profiler trace and see if SQL server AUTO-STATS?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply