what is statistics



what is statistics..

Answer / sam

statistics in SQL Server refers specifically to information
that the server collects about the distribution of data in
columns and indexes. This data in turn is used by the query
optimizer to determine the plan of attack for returning
results when you run a query. While in the majority of
cases SQL Server takes care of this statistical
recordkeeping for you automatically, it's useful to have
some understanding of what's going on, and to know when you
might need to intervene.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What are the different types of sql server replication? : sql server replication

0 Answers  


plz send every query in sql server2000

1 Answers   Infosys,


how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

0 Answers   United Healthcare,


What is explicit mode in sql server?

0 Answers  


What are distinctive joins find as a part of sql?

0 Answers  






How do you troubleshoot errors in a SQL Server Agent Job?

0 Answers  


What is the user of Primary key?

0 Answers  


How can you insert null values in a column while inserting the data?

0 Answers  


How do I determine how many instances of sql server are installed on a computer?

0 Answers  


What is difference between count (*) and count column?

0 Answers  


Explain indexed view?

1 Answers  


What are the lambda triggers?

0 Answers  


Categories