Answer Posted / 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 View All Answers
what is an index? : Sql server database administration
Difference between report and query parameter.
What is sub-query in sql server?
Explain the concept of recursive stored procedure.
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
Relational calculus is what type of language?
How do I create a partition table in sql server?
How to add the custom code in Report?
How to create a testing table with test data in ms sql server?
What are the approximate numeric data types?
What is the difference between seek predicate and predicate?
To which devices can a backup be created and where should these devices be located? : sql server management studio
How to configure and test odbc dsn settings?
What is query optimization process?
Define cross join in sql server joins?
