Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what is statistics

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


Please Help Members By Posting Answers For Below Questions

Explain about Normalization?

1120


How to create a dynamic cursor with the dynamic option?

1099


What is sql injection and why is it a problem? : sql server security

1184


How to include text values in sql statements?

1094


What are the requirements to use odbc connections in php scripts?

1154


How to drop existing views from a database in ms sql server?

1143


What is the cartesian product of table?

1060


What is the osql utility?

1033


What is default constraint?

1051


How do I partition a table in sql server?

1097


What causes index fragmentation?

1043


What to check if a User database is locked?

1112


What do you understand by the denormalisation?

1016


What is dbcc?

1179


What happens if you delete a table that is used by a view?

1059