"Strange, John W" wrote:
> Am I reading this right in that the sort is taking almost 8
> seconds?
> -> Sort ... actual time=14186.977..14287.068
> -> Hash Join ... actual time=6000.728..12037.492
The run time of the sort is the difference between 12037 ms and
14287 ms (the completion times). That's 2.25 seconds.
> If you are not the intended recipient, you are hereby notified
> that any disclosure, copying, distribution, or use of the
> information contained herein (including any reliance thereon) is
> STRICTLY PROHIBITED.
You probably already know this, but just to make sure -- you posted
this to a public list which is automatically replicated to several
websites freely available to everyone on the planet.
-Kevin