what is update statistics in sybase?



what is update statistics in sybase?..

Answer / Sandhya Tripathi

Update Statistics is a Sybase command used to refresh the distribution and usage information of indexes, statistics, and columns. This process helps the query optimizer to make better decisions about which indexes to use for a given query, improving performance.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Sybase Interview Questions

What do you mean by adaptive server enterprise?

1 Answers  


What causes re-resolution of a stored procedure in sybase?

1 Answers  


How does partition assignment relate to transactions in sybase?

1 Answers  


How do I add a sybase driver to sql developer?

1 Answers  


What is the depth of triggers?

1 Answers  


What measures are there to increase the db space?

1 Answers  


Is sybase owned by sap?

1 Answers  


What is the difference between db-lib and ct-lib in sybase?

1 Answers  


How do I check if log truncation is blocked in sybase?

1 Answers  


What happen when we delete the table using trigger?

1 Answers  


How do the blocker processes exist internally in sybase?

1 Answers  


What is the difference in storage type of numeric and decimal data types in sybase ?

1 Answers  


Categories