Answer Posted / 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 |
Post New Answer View All Answers
Why we use trigger in sql server with example?
Tell me what is normalization? Explain different forms of normalization?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
What is the federation in sql azure?
Explain an incremental backup?
What is transact-sql language?
What is partition, how will you implement it? : sql server analysis services, ssas
How do you set a trace flag in sql server?
How can you insert values in multiple rows using one Insert statement?
Why use view instead of a table?
What program is used to store the data source file?
How to drop existing views from a database in ms sql server?
Explain about the command-line tool SQLCMD?
How to create stored procedures with parameters in ms sql server?
What are the types of stored procedures in an sql server?