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
Differentiate between ms sql server reporting services vs crystal reports?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What are tables in sql server?
How can I change procedure name in sql server?
How do you open a cluster administrator?
What are “lock” hints?
Can I save my report as html, excel or word? : sql server management studio
What are advantages of ssrs or why we should use ssrs?
What is tablesample?
What is bcp? When does it used?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
How many databases instances are there in sql server 2000?
How to drop existing indexes in ms sql server?
What is the fastest way to permanently delete a 1 million row table named customers?
What will be query used to get the list of triggers in a database?