Re: SQL syntax appears correct but EXPLAIN does not work?
I split the UPDATE into 3 UPDATES, total runtime for all three in series was 10 seconds! what a difference when the idexes can be used.
David
Subject
Views
Written By
Posted
5049
July 10, 2005 09:25AM
2457
July 10, 2005 11:55AM
2762
July 18, 2005 08:17AM
2799
July 18, 2005 09:04AM
2371
July 18, 2005 09:04AM
2649
July 18, 2005 09:57AM
Re: SQL syntax appears correct but EXPLAIN does not work?
2392
July 18, 2005 10:54AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.