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 |
How to connect php with different port numbers?
Can we add our custom code in ssis?
What is a trigger?
What is the purpose of sql profiler in sql server?
What happens when converting big values to integers?
What is the maximum size of sql server database?
What is dirty read?
What is the command dbcc checkdb used for?
What is an execution plan? How would you view the execution plan?
What are cursors in ms sql server?
What type of Index will get created after executing the above statement?
Tell me what are cursors and when they are useful?