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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is the query optimization statistics?

Question Posted / guest


What is the query optimization statistics?..

Answer / 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

More SQL Server Interview Questions

Explain following error properties?

0 Answers  

How to get the definition of a stored procedure back?

0 Answers  

What is cursor ? And what is difference between Trigger ?

3 Answers   HCL, Polaris,

What is the difference between char and varchar2 datatype in sql?

0 Answers  

How do I create a partition table in sql server?

0 Answers  

How sql server enhances scalability of the database system?

0 Answers  

What are the different editions available in sql server 2000?

0 Answers  

How to create hyperlink from returned sql query ?

0 Answers   MCN Solutions,

What are the recovery models in sql server 2000?

0 Answers  

what is package and it uses and how can u call a package

0 Answers   Satyam,

Explain sp_configure commands, set commands?

3 Answers  

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?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories