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
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
What do you mean by recursive stored procedure?
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
To which devices can a backup be created and where should these devices be located? : sql server management studio
How do I run a trace in sql server?
what are the new features introduced in sql server 2000? : Sql server database administration
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
How to use “drop” keyword in sql server and give an example?
How to stop a loop early with break statements in ms sql server?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
How do you start single user mode in clustered installations?
Explain aggregate functions?
Ms sql server index?
What is TDS(Tabular Data Stream) Gateway?
Write a program to fetch first 10 records from a file?