Re: SORT performance - slow?

"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