What is the query optimization statistics?
- 1 Answers
- 2543 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 |
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
Difference between primary key and clustered index?
is there more the two primary key in a single table?
26 Answers Eforce, Systematix,
how many bits ip address consist of? : Sql server database administration
Does union all remove duplicates?
What are statistics?
What is the server name for sql management studio?
What does this statement do @@rowcount?
What does nvl stand for?
How to drop an existing table with "drop table" statements in ms sql server?
List some of the rules that apply to creating and using a ‘view’
Issues related in upgrading SQL Server 2000 to 2005 / 2008
-
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 (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
