My question is how can SQL server display the information about the buckets when doing the hash join just like the function of Trace Event 10104 in Oracle.By the way ,In Oracle ,the Event 10104
event dumps hash join statistics .
The buckets message what i needed is similar as the following,that is to say ,it must contains the information about buckets .
01 ### Hash table ###
02 # NOTE: The calculated number of rows in non-empty buckets may be smaller
03 # than the true number.
04 Number of buckets with 0 rows: 16373
05 Number of buckets with 1 rows: 0
06 Number of buckets with 2 rows: 0
07 Number of buckets with 3 rows: 1
View Complete Post