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

Why we use trigger in sql server with example?

1013


Tell me what is normalization? Explain different forms of normalization?

1075


John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

983


What is the federation in sql azure?

97


Explain an incremental backup?

1050


What is transact-sql language?

1135


What is partition, how will you implement it? : sql server analysis services, ssas

1100


How do you set a trace flag in sql server?

1093


How can you insert values in multiple rows using one Insert statement?

1151


Why use view instead of a table?

1003


What program is used to store the data source file?

1005


How to drop existing views from a database in ms sql server?

1147


Explain about the command-line tool SQLCMD?

1144


How to create stored procedures with parameters in ms sql server?

1156


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

1034