Re: tune between query/join

From: Sriram Kumar <k.sriramkumar_at_gmail.com>
Date: Fri, 21 Oct 2011 12:45:42 +0530
Message-ID: <CAEq4C0fSsYc57RKmm8C3G=MHStuUiFqQLKLGU4-XJ=rPN_P2PA_at_mail.gmail.com>



Hi,
Cartesion join for a amount slab looks to be killing. Are you missing a a.account_number=b.account_number clause?.

Best Regards

Sriram Kumar

On Fri, Oct 21, 2011 at 11:11 AM, amonte <ax.mount_at_gmail.com> wrote:

> 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
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 21 2011 - 02:15:42 CDT

Original text of this message