DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13
  1. #11
    Join Date
    Mar 2004
    Table-Gathering statistics for a table,will touch its indexes also ?or need to do it seperatly.
    No (in general - need to set in query)
    Yes (in your case)
    Last edited by dbasan; 06-05-2007 at 10:50 AM.

  2. #12
    Join Date
    Nov 2002
    Mooresville, NC


    I pointed out out frequency beacuse, if you run gather stats job weekly once and still face performance problems and after analyzing it seemsexplain plan is not good enough because of volume of data updated or inserted, then you need to gather stats more than once a week.

    Hope this clarifies.
    A performance engineering forum

  3. #13
    Join Date
    Mar 2007
    Ft. Lauderdale, FL
    are you changing more than 20% of your data a week?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.