When Is The Use Of Update_statistics Command?

1.	When Is The Use Of Update_statistics Command?
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. 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.

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.

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.

Discussion

No Comment Found

Related InterviewSolutions

What Function Catx Syntax Does?
Mention The Validation Tools Used In Sas?
Explain How You Can Debug And Test Your Sas Program?
In Sas Explain Which Statement Does Not Perform Automatic Conversions In Comparisons?
Explain What Is Pdv?
Explain What Is Data Step?
Explain What Is The Basic Structure Of Sas Programming?
Explain What Is Sas? What Are The Functions Does It Performs?
Name Several Ways To Achieve Efficiency In Your Program.
If Reading A Variable Length File With Fixed Input, How Would You Prevent Sas From Reading The Next Record If The Last Variable Didn't Have A Value?