Interested to Buy Any Domain ? << Click Here >> for more details...
When do we use the UPDATE_STATISTICS command?
- 4 Answers
- 19045 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
How to create indexed view?
How do I change my passwords (database, LDAP, and so on) without causing an outage?
How to create function with parameter in sql server?
What happens on checkpoint?
What are four major operators that can be used to combine conditions on a where clause?
What is the difference between clustered index and primary key?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
What are clustered and non-clustered index?
What is the use of “join” in sql server?
How to copy data from one table to another table?
What is Service Broker in sql server 2012?
List some of the rules that apply to creating and using a ‘view’
How to disable a login name in ms sql server?
List few advantages of stored procedure.
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
