Interested to Buy Any Domain ? << Click Here >> for more details...
What is the purpose of UPDATE STATISTICS?
- 2 Answers
- 13836 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
Updates information about the distribution of key values for
one or more statistics groups (collections) in the specified
table or indexed view.
| Is This Answer Correct ? | 8 Yes | 3 No |
Answer / sambashiva
This is used after inserting huge rows into table or deleting from a table the pages of the index will be not in the proper way so by running this thing we can bring them to proper way.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the meaning of sql server?
plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005
What does the INSTEAD OF trigger do?
What is the difference between varchar and nvarchar types?
What are cursors stored procedures and triggers?
Does the unique constraint create an index?
Why variables called the most powerful component of ssis?
What is difference between foreign key and unique key?
Which are the third-party tools used in sql server and why would you use them?
How to include date and time values in sql statements?
A left outer join B B right outer join A gives the same result then what is the use of two?
Why we need to use secondry database file? though, we can do same work using primary database file also.
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
