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
Explain about Normalization?
How to create a dynamic cursor with the dynamic option?
What is sql injection and why is it a problem? : sql server security
How to include text values in sql statements?
What are the requirements to use odbc connections in php scripts?
How to drop existing views from a database in ms sql server?
What is the cartesian product of table?
What is the osql utility?
What is default constraint?
How do I partition a table in sql server?
What causes index fragmentation?
What to check if a User database is locked?
What do you understand by the denormalisation?
What is dbcc?
What happens if you delete a table that is used by a view?