Interested to Buy Any Domain ? << Click Here >> for more details...
What is the query optimization statistics?
- 1 Answers
- 2800 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 is sql server schema compare? How we can compare two database schemas?
What is difference between joins and subqueries?
When do you use SQL Profiler?
What are transactions in sql?
What is the purpose of object explorer and its features? : sql server management studio
How can you insert values in multiple rows using one Insert statement?
0 Answers Flextronics, Thomson Reuters, Virtusa,
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What are the different authentication modes in sql server? How can it be changed?
how to count datewise data in sqlserver
4 Answers CarrizalSoft Technologies, IndusInd Bank,
What is the role that is required for killing a process What is the role that is required for creating a linked server
1 Answers CarrizalSoft Technologies, IBM,
What are the disadvantages of primary key and foreign key in SQL?
What is DCL?
-
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)
