Post reply

Update Usage and Statitics

  • February 11, 2005 at 8:39 am

    #87592

    Do you have to update usage and statistics on all tables on the database even though you reindex the whole database every night?  Thanks

  • February 11, 2005 at 11:14 am

    #541856

    I was suppose to test this. Good now i will wait for the answer and do other projects

     

    Kindest Regards,

    Amit Lohia

  • February 11, 2005 at 2:38 pm

    #541899

    When you rebuild indexes, the statistics do get recomputed. If you want to create indexes without rebuilding statistics, than you can use the create index statement with STATISTICS_NORECOMPUTE clause.

  • February 11, 2005 at 4:17 pm

    #541916

    Thanks for the input!  I just have one more question to ask. If a vendor puts statistics on fields that are not indexed at all, do you still need to update the usage and statistics?  Thanks for all your help.

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

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