When is the use of UPDATE_STATISTICS command?

Add comment

Votes: 0

Comments: 0

This command is basically used when a large processing of data has occurred. If a large amount of deletions any modification or Bulk Copy into the tables has occurred, it has to update the indexes to take these changes into account. UPDATE_STATISTICS updates the indexes on these tables accordingly.

Others in this Category

	What is De-normalization?
	Q: Explain the concept of NULL
	What is NOT NULL Constraint?
	Q: When do you use WHERE clause and when do you use HAVING clause?
	What are the different index configurations a table can have?
	What are the advantages of using Stored Procedures?
	How can we rewrite sub-queries into simple select statements or with joins?
	How to get @@ERROR and @@ROWCOUNT at the same time?
	Name 3 ways to get an accurate count of the number of records in a table?
	Q: Please explain Outer Join in SQL
	» More articles