solutions related to sql queries

Share with your friends

Author: Reena_579e864d (Reena Sharma) View Profile | View other solutions by this author

Question / Problem

When is the use of UPDATE_STATISTICS command?

Solution

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.

Applies to

My Sql

Rank It

Report