tune between query/join

From: amonte <ax.mount_at_gmail.com>
Date: Fri, 21 Oct 2011 07:41:10 +0200
Message-ID: <CABV7K9uXTK44Env53vX0D5rtdG2N8jK7Gq51OcavTSaZ4Zy36g_at_mail.gmail.com>

Hello everyone
I am running a query which looks like following (running in 10.2.0.4):

select a.account_number, a.id, b.*
  from account a, tmp_account b
where b.amount between a.lowest_amount and a.highest_amount

account has 8000000 rows and tmp_account 150000, the execution plan shows merge sort join as expected, this query takes around 5 hours to run, is there anyway to improve this?

Alex

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Oct 21 2011 - 00:41:10 CDT