Interested to Buy Any Domain ? << Click Here >> for more details...
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 the difference between createstatement and preparedstatement?
What do you mean by data integrity?
Can we use pragma autonomous_transaction in trigger?
what are candidate key, alternate key and composite key? : Sql server database administration
What is the difference between for trigger and after trigger?
How many databases instances are there in sql server 2000?
Explain contrast amongst grouped and non-bunched records?
What are the restraints imposed on the table design by a merge replication?
List the different types of collation sensitivities in sql server?
What is acid db?
How to loop through result set objects using odbc_fetch_row()?
What are Spatial data types in SQL Server 2008
How to return the date part only from a sql server datetime datatype?
What is difference between equi join and inner join?
What is the main difference between ‘between’ and ‘in’ condition operators?
