Re: Really slow query .. is there a better approach??

jobs wrote:
> select p.phone,p.account_number,o.amount from users_phones p, orders
> o
> where p.account_number = o.account_number and p.status=1 and p.eci=0
> and o.validation_date > sysdate-15
> and p.btn=1 and o.status=1 and o.id =(select min(oo.id) from orders
> oo
> where oo.ACCOUNT_NUMBER=p.account_number and oo.amount>0 and
> oo.validation_date > sysdate-15)
>
>
> if I run the code up to the "and o.id" It selects 54 rows really fast.
>
> The orders table should only have about 10 to 20 orders per Id. So why
> dos the addition of that min(oo.id) code significantly slow me down.
>
> Is there a better approach.
>
> Thanks in advance for any help or information!

Oracle version number?
Explain plan run with DBMS_XPLAN?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org