When do we use the UPDATE_STATISTICS command?
Answers were Sorted based on User's Feedback
Answer / guest
This command is basically used when we do a large processing
of data. If we do a large amount of deletions any
modification or Bulk Copy into the tables, we need to
basically update the indexes to take these changes into
account. UPDATE_STATISTICS updates the indexes on these
tables accordingly.
| Is This Answer Correct ? | 34 Yes | 6 No |
Answer / sivakumar
That command is used to rebuild indexes on tables, which
can speed up queries. You might want want to do it whenever
a large amount of data has been deleted or added. It can be
complicated to determine whether it is more efficient to do
this, or to just let the statistics rebuild automatically
so, as usual, testing is called for in each individual case
to get optimal performance.
| Is This Answer Correct ? | 7 Yes | 3 No |
Answer / nscom
There are three scenarios where you need to fire the update
statistics
1. Query execution times are slow.
2. Insert Operations Occur on Ascending or Descending Key
Columns
3. After Maintenance Operations - Operations that change the
*distribution of data" such as truncating a table or
performing a bulk insert of a large percentage of the rows.
More information is here
http://msdn.microsoft.com/en-us/library/ms190397.aspx#UpdateStatistics
| Is This Answer Correct ? | 2 Yes | 0 No |
What is blocking and how would you troubleshoot it?
Difference between sql server 2000 and sql server 2005?
11 Answers Aditi Tech, eInfochips, GE, HCL, IBM, Masim Infotech, NIIT, Satyam, Systems Domain,
What is the new security features added in sql server 2014? : sql server security
what's the difference between delete table and truncate table commands? : Sql server database administration
What are triggers in ms sql server?
Where in ms sql server is ’100’ equal to ‘0’?
What are the new scripting capabilities of ssms? : sql server management studio
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
How many types of dimensions are there and what are they? : sql server analysis services, ssas
What is the purpose of indexing?
How do I start sql server 2016?
How to find out name of all employees who has salary less than 200 Rs.?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)