Re: Update on unreasoabley slow SQL statement.

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

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