Post reply

what does recompute statistics do and is this recommended

  • November 16, 2005 at 4:41 pm

    #152623

    1.what does recompute statistics do and is this recommended

     

     

    2.in the database maintanence wizard it asks why to if want to rebuild indexes, is this a good idea, is this the same as reindexing which happens as records are added?

    thanks!

     

  • November 18, 2005 at 4:41 pm

    #604764

    Recompute statistics will update statistics on all tables in the database.  This is highly recommended.  Poor stats will lead to poor performance.

    Rebuilding an index is synonamous with reindexing.  As records are added to a table with index(es), indexes become fragmented.  Rebuilding or defragging these indexes are nessecary to maintain optimal performance. 

     



    A.J.
    DBA with an attitude

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

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