analyze Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: analyze

  1. #1
    Join Date
    Jan 2001


    Is it a good idea to analyze objects in production database once every day? why?

    Let me know.


  2. #2
    Join Date
    Nov 2000
    Depends on how often they change. If you have a table that gets a massive amount of update/delete/insert activity, then yes, it might be appropriate to analyze every night. If the majority of your data is relatively static, you could analyze less often.
    Jeff Hunter
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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