Interested to Buy Any Domain ? << Click Here >> for more details...
When do we use the UPDATE_STATISTICS command?
- 4 Answers
- 18837 Views
- Deutsche Telekom AG, I also Faced
- E-Mail Answers
Answer Posted / guest
This command is basically used when we do a large processing
of data. If we do a large amount of deletions any
modification or Bulk Copy into the tables, we need to
basically update the indexes to take these changes into
account. UPDATE_STATISTICS updates the indexes on these
tables accordingly.
| Is This Answer Correct ? | 34 Yes | 6 No |
Post New Answer View All Answers
Explain the advantages of merge replication?
What is difference between count (*) and count column?
How can I create a new template for import ? : sql server management studio
What are clustered and non-clustered index?
What function does a database engine serve in the sql server?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
How many triggers are possible per table?
What are a scheduled jobs?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
Do you know what are acid properties of transaction?
What does the update command do?
If a table does not have a unique index, can a cursor be opened on it?
What are the tool windows in sql server management studio? : sql server management studio
How to get a list all databases on the sql server?
How to choose all records from the table?
