When is the use of UPDATE_STATISTICS command?

suthis sir ,i know the answer of each question that i have posted,I 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 Nayak13y ago

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 Nair13y ago

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