Post reply

Re-indexing and Stats

  • March 24, 2003 at 8:43 am

    #63271

    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

    #451897

    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

    #451910

    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

    #451923

    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