Re: Update on unreasoabley slow SQL statement.

stanb_at_netcom.com (Stan Brown) writes:

>Newsgroups: comp.databases.oracle
>Subject: Re: Update on unreasoabley slow SQL statement.
>References: <stanbD0089u.I04_at_netcom.com>

> I thought people might like to hear the final solution to
>this problem. It turns out that our SQL statement was confusing the
>optimizer. Note that the statement *did* preformm the correct action,
>but took a *long* time
 

> Here is the original statement:
 

> DELETE FROM table_a where min in
> (SELECT min from table_b)
 

> Here is the fixed one:
 

> DELETE FROM table_a where table_a.min in
> (SELECT table_b.min from table_b)
 

> Many thanks to Francesca Buiman at Oracle support for her tireless
 Sorry that's Budiman
>efforst in helping us track down and solve this problem.
 

>Stan Brown
 

>--
>Stan Brown stanb_at_netcom.com 404-996-6955
>Factory Automation Systems
>Atlanta Ga.
>--
>DOS ... is still a real mode only non-reentrant interrupt
>handler, and always will be. -Russell Williams
 

-- 
Stan Brown     stanb_at_netcom.com                                    404-996-6955
Factory Automation Systems
Atlanta Ga.
--
DOS ... is still a real mode only non-reentrant interrupt
handler, and always will be.                -Russell Williams