Explain What is Update Statistics?

Rashmi121

 Profile Answers by Rashmi121 Questions by 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 informat...

wramakrishna

 Profile Answers by wramakrishna Questions by 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 in...

Answer Question  Select Best Answer