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

chrisjej

 Profile Answers by chrisjej Questions by chrisjej

• Jun 23rd, 2010

select count(*) does not need to fetch all column data - which you can see whenever the showplan chooses to perform the query using an index.I doubt there is a difference - and when I just tried to be...

gcvpgeek

 Profile Answers by gcvpgeek Questions by gcvpgeek

• Jun 23rd, 2009

Count(1) is faster than count(*)

Answer Question  Select Best Answer