Re: SQL syntax appears correct but EXPLAIN does not work?
Yes, using a UNION makes perfect sense, except that I had modified the original UPDATE so I could use EXPLAIN. In the context of the UPDATE I cannot use the UNION because because the sub-select would contain the table being updated. See the first message in this thread for my original query.
Look slike I will have to use a temp table again.
Does your book cover the way the optimiser works Jay? If it does I cannot wait until it is on the shelves!
Regards,
David
Subject
Views
Written By
Posted
4683
July 10, 2005 09:25AM
2275
July 10, 2005 11:55AM
2533
July 18, 2005 08:17AM
2544
July 18, 2005 09:04AM
2220
July 18, 2005 09:04AM
Re: SQL syntax appears correct but EXPLAIN does not work?
2397
July 18, 2005 09:57AM
2248
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.