Update Statistics

Explain What is Update Statistics?

Questions by srihari_d   answers by srihari_d

Showing Answers 1 - 2 of 2 Answers

wramakrishna

  • Mar 26th, 2008
 

The update statistics command helps the server make the best decisions about which indexes to use when it processes a query, by providing information about the distribution of the key values in the indexes.   The update statistics commands create statistics, if there are no statistics for a particular column, or replaces existing statistics if they already exist. The statistics are stored in the system tables systabstats and sysstatistics.

  Was this answer useful?  Yes

Rashmi121

  • May 9th, 2008
 

ASE uses two system tables for maintaining stats on tables for obtimized query and data retrival.
systabstats is used on table level and is maintained dynamically while sysstatistics maintains information on columns and is not maintained.Update statistcis is used to update the information in system tabels for ASE use.It shoudl be run in off-peak hours.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions