"Dirschel, Steve" writes:
> The query and execution plan are shown below. My question is
> related to the result set the optimizer is choosing to build the
> hash table from. My understanding is for a hash join you want to
> build the hash table out of the smaller result set.
That's *a* conside
The query and execution plan are shown below. My question is related to the
result set the optimizer is choosing to build the hash table from. My
understanding is for a hash join you want to build the hash table out of the
smaller result set. If you look at the execution plan below you can se
