What is the query optimization statistics?
- 1 Answers
- 2571 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 |
What objects does the fn_my_permissions function reports on? : sql server security
How to enter unicode character string literals in ms sql server?
How to create a dynamic cursor with the dynamic option?
What is entity data services?
How exceptions can be handled in sql server programming?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
How to delete all rows with truncate table statement in ms sql server?
What is the difference between upgrade and migration in sql server?
Can we add our custom code in ssis?
What are the restrictions that views have to follow?
How do I create an extended event in sql server?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
-
Oracle (3258) - 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)
