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 the properties of the relational tables?
Explain can SSRS reports Cache results?
Write a sql query to get zero records from a table having n number of records?
what is package and it uses and how can u call a package
What is trigger explain with program?
How to insert and update data into a table with "insert" and "update" statements?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
How to create a large table with random data for index testing in ms sql server?
How to connect Azure federated root database and apply federation in entity framework?
How to list all tables in the database using odbc_tables()?
What is lock escalation and what is its purpose?
How do I get Report Builder to generate a parameter that can be set by users viewing the report?
How do I debug a stored procedure in sql server?
What is bit data type? What's the information that can be stored inside a bit column?
What is merge statement?