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

What is difference between index and primary key?

1135


What is a virtual table in sql?

1033


What is the difference between delete and truncate statements?

1124


What is the maximum size of a row in sql server?

999


How to update muliple row in single query?

1107


What is a functions and types in sql server?

1139


What are the different types of normalization?

1216


What is the maximum size per database for sql server express?

1095


Is mysql the same as sql server?

1024


you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

993


Why would you use sql agent?

1335


List some of the rules that apply to creating and using a ‘view’

916


What are triggers in ms sql server?

1220


What are locks in sql?

1008


Can we insert data into view sql server?

976