Interested to Buy Any Domain ? << Click Here >> for more details...
What is the purpose of UPDATE STATISTICS?
- 2 Answers
- 13933 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 the class forname () does?
What is the difference between grant and with grant while giving permissions to the user?
What is a performance monitor?
if no size is defined while creating the database, what size will the database have? : Sql server administration
what is the difference detween pairwise comparison subquary and non pairwise comparison subquary?
Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.
How do you use DBCC statements to monitor various aspects of a SQL server installation?
What is normalization 1nf 2nf 3nf?
what is victor class
What are out-of-range errors with date and time literals?
What are the types of joins in sql?
Where do we generally create INDEX?
1 Answers Ernst Young, Thomson Reuters,
-
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)
