| |
GeekInterview.com > Interview Questions > Database > Sybase
| Print | |
Question: Update Statistics
Answer: Explain What is Update Statistics? |
| March 03, 2008 00:13:46 |
#1 |
| wramakrishna |
Member Since: March 2008 Total Comments: 1 |
RE: Update Statistics
|
| 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. |
| |
Back To Question | |
