Monday, June 8, 2009

Gather Schema Statistics

Sometimes , after continuous updating,inserting or deleting of data by users(Functional,technical
or End users), it becomes necessary to gather statistics as the performance of database becomes slow.

This can be done by simply submitting a request from Front-End Forms service...which substantially improves the performance of the Application and Database.





2 comments:

  1. Hi,
    In case of an instance where there are high number of transactions, what should be the frequency and what should be the parameters to run "Gather Schema Statistics"

    ReplyDelete
  2. In case of high number of transactions ie. 1)frequent data changes
    2) Data imports
    3) Performance deterioration

    Usually,It is advised to run this program
    1)on the module with slow performance with higher estimate percent (say 70-80%)
    2)or for all Schemas with 40 to 50 percent.

    But there is no hard and fast rule as such.

    In case of heavy data changes,
    We can schedule this to run every day at off-peak hours with a minimum estimate percent or weekly with 80 to 90 percent.

    Thanks

    ReplyDelete