What about UPDATESTATISTICS ?
Answers were Sorted based on User's Feedback
Answer / rajesh ranjan
Hi
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.
Is This Answer Correct ? | 9 Yes | 0 No |
Answer / anand
The UPDATE STATISTICS statement defines the storage
requirements of tables and indexes as well as the value
distribution of columns, and stores this information in the
database catalog.
Syntax
<update statistics statement> ::=
UPDATE STAT[ISTICS] COLUMN <table name>.<column name>
[ESTIMATE [<sample definition>]]
| UPDATE STAT[ISTICS] COLUMN (<column name>,...) FOR <table
name> [ESTIMATE [<sample definition>]]
| UPDATE STAT[ISTICS] COLUMN (*) FOR <table name> [ESTIMATE
[<sample definition>]]
| UPDATE STAT[ISTICS] <table name> [ESTIMATE [<sample
definition>]]
| UPDATE STAT[ISTICS] [<owner>.][<identifier>]* [ESTIMATE
[<sample definition>]]
Is This Answer Correct ? | 0 Yes | 0 No |
What is the need for group functions in sql?
What is a with(nolock)?
What do you understand by sql server agent?
Accidentally i deleted my table. How can i get that table?
What are pages and extents? : SQL Server Architecture
How to perform backup for certificates in sql server? : sql server security
What is the Disadvantage of indexed sequential file.
What is Peer to peer Replication?
1 Answers CarrizalSoft Technologies, HCL,
What are the different types of triggers in SQL SERVER?
What is the fastest way to permanently delete a 1 million row table named customers?
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
Explain primary key in sql server?