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
What is difference between index and primary key?
What is a virtual table in sql?
What is the difference between delete and truncate statements?
What is the maximum size of a row in sql server?
How to update muliple row in single query?
What is a functions and types in sql server?
What are the different types of normalization?
What is the maximum size per database for sql server express?
Is mysql the same as sql server?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
Why would you use sql agent?
List some of the rules that apply to creating and using a ‘view’
What are triggers in ms sql server?
What are locks in sql?
Can we insert data into view sql server?