Interested to Buy Any Domain ? << Click Here >> for more details...
What is the purpose of UPDATE STATISTICS?
- 2 Answers
- 13997 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 |
How to delete duplicate rows from table except one?
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
Do you know what is user defined datatypes and when you should go for them?
What is query cost in sql server?
Explain Capacity planning to create a database? and how to monitor it?
Describe the left outer join & right outer join. : sql server database administration
how many type of subquery?
Do you know hot add cpu in sql server 2008?
Does partitioning improve performance?
what is node in sql server?
2 Answers CarrizalSoft Technologies, Google, NIIT, Nittany, TATA,
How to declare a cursor with "declare ... Cursor" in ms sql server?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
-
Oracle (3253) - 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)
