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>
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.orgReceived on Fri Dec 26 2008 - 19:33:38 CST