Question and Answer:

  Home  Sybase

⟩ Explain What is Update Statistics in Sybase?

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.


More Questions for you: