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 null values we can have in a unique key field in sql server?

958


Can we update data in a view?

1032


Explain few examples of stored procedure over triggers?

1043


What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1148


How dts is used to extract, transform and consolidate data?

1073


What is a database in ms sql server?

1057


How to find the list of fixed hard drive and free space on server?

1199


Define ACID properties in a Database?

1057


Do you know what is similarity and difference between truncate and delete in sql?

1007


What are joins in sql and what are the different types of joins?

1014


Explain difference between cross join and full outer join?

1005


What are the types of stored procedures in an sql server?

989


How do I create a trace in sql server?

1042


Can a database be shrunk to 0 bytes, if not, why?

1106


How do you manipulate data?

908