When is the use of UPDATE_STATISTICS command?

Question

Vithal Wadje · Answer

suthis sir i know the answer of each question that i have postedI wants to share these questions to freshers and they also know how to give the answer of these questions which are answerd by our C# expert members aslo the question in our interview section are not active and our members are not respondibg them

Satyapriya Nayak · Answer

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.

Suthish Nair · Answer

I will suggest you better post these type of questions to C# Corner Interview Section. www.c-sharpcorner.com/interviews/