When do we use the UPDATE_STATISTICS command?

When do we use the UPDATE_STATISTICS command?

- UPDATE_STATISTICS updates the indexes on the tables when there is 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 an account.

- It ensures that queries, compile with up-to-date statistics.

- It causes queries to recompile.

- It can be used 'tempdb' to sort the sample of rows for building the statistics.
Difference between clustered and non-clustered index
Both stored as B-tree structure. The leaf level of a clustered index is the actual data where as leaf level of a non-clustered index is pointer to data.......
Inline variable assignment in sql server 2008 - Sql server 2008
Inline variable assignment in SQL Server 2008 enables to – declare, and assign the variables in a ‘single line’..........
What is Compound Operators in sql server 2008? - Sql server 2008
Compound operators feature is enhanced in SQL Server 2008. They are like compound operators in languages like C, C++ etc..........
Post your comment

Related Content

Follow us

▲