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
How many types of subqueries are there in sql server?
How can I check that whether automatic statistic update is enabled or not?
Show Practically Sql Server Views are updatable?
What is difference between views and stored procedures?
What is bulkcopy in sql?
How will you know when statistics on a table are obsolete?
What are sql server procedures?
What is subquery explain with example?
How to create a Master database in SQL server ?
Explain in details security in SQL azure?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
How is SQL Azure different than SQL server?
What is difference between line feed ( ) and carriage return ( )?
How to configure and test odbc dsn settings?
Do you know clustered and non-clustered index?