Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
which table keeps the locking information? : Sql server administration
Explain the working of sql privileges?
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
List the types of recovery model available in sql server?
Explain triggers?
What does set rowcount do?
What is field in algebra?
What is merge replication?
What is abstracting periodical?
How to enter date and time literals in ms sql server?
What is row-level compre?
What happens if the update subquery returns multiple rows in ms sql server?
How you can change a cross join into an inner join?
What are subquery and its properties?
How to generate create function script on an existing function?
