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

How many types of subqueries are there in sql server?

989


How can I check that whether automatic statistic update is enabled or not?

1040


Show Practically Sql Server Views are updatable?

1117


What is difference between views and stored procedures?

987


What is bulkcopy in sql?

939


How will you know when statistics on a table are obsolete?

1077


What are sql server procedures?

976


What is subquery explain with example?

1057


How to create a Master database in SQL server ?

1084


Explain in details security in SQL azure?

121


Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

1017


How is SQL Azure different than SQL server?

223


What is difference between line feed ( ) and carriage return ( )?

900


How to configure and test odbc dsn settings?

1156


Do you know clustered and non-clustered index?

974