What is the query optimization statistics?

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


Please Help Members By Posting Answers For Below Questions

What are the character string functions supported by sql server 2005?

524


What is snapshot parameter in ssrs?

109


Does partitioning help performance?

531


SQL Server Architecture ?

1938


What is normalization of database?

607






What is the difference between value type and reference type?

557


Can we join two tables without primary key?

619


What is the difference between join and inner join?

541


Can we hide the definition of a stored procedure from a use?

656


Is candidate a key?

536


What is unique key constraint?

634


Explain the architecture of ms sql reporting service?

536


What is attribute hierarchy? : sql server analysis services, ssas

524


Can we install sql server 2016 on windows 7?

677


Explain transaction server auto commit?

537