dbms_stats.gather_schema_stats - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: dbms_stats.gather_schema_stats

  1. #11
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    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 11:50 AM.

  2. #12
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349

    Arrow

    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.
    http://www.perf-engg.com
    A performance engineering forum

  3. #13
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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