Explain What Is Update Statistics In Sybase?

1.	Explain What Is Update Statistics In Sybase?
Answer» 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. 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.

Answer»

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.

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.

Discussion

No Comment Found

Related InterviewSolutions

How Do You Bcp Only A Certain Set Of Rows Out Of A Large Table?
What Are The Main Advantages And Disadvantages Of Using Identity Columns?
Is There Any Disadvantage Of Splitting Up Your Application Data Into A Number Of Different Databases?
How Do You Tell The Data Time Of Server Started?
How Frequently You Defrag The Database?
What Are Constraints? Explain Different Types Of Constraints?
How Do You Force A Transaction To Fail?
How Do You Optimize A Select Statement?
How Do You Optimize A Stored Procedure?
What Are Advantage Of Using Triggers?