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
How many null values we can have in a unique key field in sql server?
Can we update data in a view?
Explain few examples of stored procedure over triggers?
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
How dts is used to extract, transform and consolidate data?
What is a database in ms sql server?
How to find the list of fixed hard drive and free space on server?
Define ACID properties in a Database?
Do you know what is similarity and difference between truncate and delete in sql?
What are joins in sql and what are the different types of joins?
Explain difference between cross join and full outer join?
What are the types of stored procedures in an sql server?
How do I create a trace in sql server?
Can a database be shrunk to 0 bytes, if not, why?
How do you manipulate data?