What is the query optimization statistics?
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 partitioned view?
Which data type can be used only on OUTPUT parameters of the stored proceduer?
What is the difference between functions and scalar functions?
What are approximate numeric data types in ms sql server?
last function used in MS Access to convert sql what function will use in sql
Do you know what is xpath?
What are secondary xml indexes?
Wht is SQL Injection Attack ?
What are the types of table?
There is a table1 with records (1,2,3,4,5,6) and table2 with records (4,5,6,7,8,9).write a query so as to get the result as 1,2,3,4,5,6,7,8,9
How will you make an attribute not process? : sql server analysis services, ssas
Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer
Oracle (3253)
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)