Post reply

When dropping/recreate indexes, do statistics too?

  • August 16, 2004 at 8:13 am

    #86284

    I'm putting together scripts to drop indexes while large amounts of data is imported. Then I will recreate the indexes. I notice that many of the tables have statistics listed when you query the index information.

    What are best practices:

    1) Do I have to drop and recreate the stats too?

    2) Or will recreating the indexes rebuild these automatically?

    3) Can I simply recreate the indexes then run sp_updatestats for all tables?

    Thanks!

     


    smv929

  • August 17, 2004 at 1:41 am

    #519267

    Third one sounds good.

    Thanks,

    Ganesh

  • August 18, 2004 at 1:10 am

    #519498

    If your database is set to auto create statistics and auto update statistics, don't worry about things. SQL Server will create the statistics as you query the table/indexes which is what you want.

     

    Julian Kuiters
    juliankuiters.id.au

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply