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 difference between temp table and cte?
Can foreign key be deleted?
What is acid db?
How many databases Microsoft SQL server provides?
What is pessimistic concurrency?
How to write a query with a left outer join in ms sql server?
What is instead of dml trigger?
What is logon trigger?
Explain syntax for dropping triggers?
Explain what are the restrictions while creating batches in sql server?
What do you mean by acid?
Can a unique index be created on a column, which contains null?
Explain the first normal form(1nf)?
Which rendering formats are affected by the pagesize properties?
What do you understand by SQL*Net?
