Re: Improving Performance of Hash Joins

From: Greg Rahn <greg_at_structureddata.org>
Date: Fri, 26 Dec 2008 17:33:38 -0800 (PST)
Message-ID: <b1c22482-da29-4ceb-8e80-75da20f660ae@f40g2000pri.googlegroups.com>


On Dec 25, 12:04 pm, zigzag..._at_yahoo.com wrote:
> What are my options (if any) to improve performance of this hash joins
> which for some queries take 2-3 minutes.

Out of curiosity, what metrics do you have that points to the hash join being the slow part of the execution plan? Could the problem be elsewhere in the execution plan?

--
Regards,
Greg Rahn
http://structureddata.org
Received on Fri Dec 26 2008 - 19:33:38 CST

Original text of this message