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 a benefit of using an after insert trigger over using a before insert trigger?
How to create function with parameter in sql server?
How to get @@error and @@rowcount at the same time?
What is sql stored procedure?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
What is store procedure?
What is tabulation?
What is difference between order by and group by?
can any body tell me how to know the password of current user in sql server
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
Can a function call a stored procedure in sql server?
What is the use of nvl work?
SQL Server Architecture ?
What are the purposes of floor and sign functions?
How to count groups returned with the group by clause in ms sql server?
