Interested to Buy Any Domain ? << Click Here >> for more details...
What is the query optimization statistics?
- 1 Answers
- 2785 Views
- I also Faced
- E-Mail Answers
Answer / flora
The SQL Server query optimizer uses distribution statistics when creating a query plan. The statistics provide information about the distribution of column values across participating rows, helping the optimizer better estimate the number of rows, or cardinality, of the query results
| Is This Answer Correct ? | 0 Yes | 0 No |
how to control the amount of free space in your index pages? : Sql server database administration
What is the difference between a function and a stored procedure?
What is sub query and its properties?
What is transact-sql ddl trigger?
How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table?
15 Answers Leo Technologies, Mannar Company, Synechron,
What happens when unicode strings concatenate with non-unicode strings?
what is a cursor and what is its use?
What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.
How will you decide the active and passive nodes?
What are various limitations of the views?
How do you load large data to the SQL server database?
Which data type can be used only on OUTPUT parameters of the stored proceduer?
-
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)
