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 the query optimization statistics?

Answer Posted / flora

The SQL Server query optimizer uses distribution statistics when creating a query plan. The statistics provide information about the distribution of column values across participating rows, helping the optimizer better estimate the number of rows, or cardinality, of the query results

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between ms sql server reporting services vs crystal reports?

857


How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

997


What are tables in sql server?

975


How can I change procedure name in sql server?

982


How do you open a cluster administrator?

1013


What are “lock” hints?

1008


Can I save my report as html, excel or word? : sql server management studio

911


What are advantages of ssrs or why we should use ssrs?

135


What is tablesample?

1040


What is bcp? When does it used?

932


How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1163


How many databases instances are there in sql server 2000?

1031


How to drop existing indexes in ms sql server?

1022


What is the fastest way to permanently delete a 1 million row table named customers?

1174


What will be query used to get the list of triggers in a database?

962