Answer Posted / Bijay Kumar
The UPDATE STATISTICS command in SQL Server is used to maintain the statistical information about data distribution in a table or index. This helps improve the performance of queries by providing better optimization.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to enter binary string literals in ms sql server?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Is it possible to have clustered index on separate drive from original table location?
Why we use the openxml clause?
How can you append an identity column to a temporary table?
What are the source of constraints?
What is standby servers? Explain types of standby servers.
Can one drop a column from a table?
Why should you use or avoid select * statements?
How do I find query history in sql server?
Explain “row_number()” in sql server with an example?
Where can you add custom error messages to sql server?
What are the properties of the transaction?
Equi join and non equi join is possible with sql server?
What is an indexed view?
