Re: no optimization?
Posted by:
Uwe
Date: June 21, 2006 10:40AM
Thanks for the link (never thought about looking for that in "subqueries") - and there's the answer:
... For example, the following two statements are semantically equivalent (although currently only the second one can be optimized):
SELECT * FROM t1 WHERE (column1,column2) = (1,1);
SELECT * FROM t1 WHERE column1 = 1 AND column2 = 1;
So an optimization for this syntax is just not supported yet.
Thanks
Uwe
Subject
Views
Written By
Posted
2490
May 22, 2006 05:47AM
1842
June 18, 2006 08:50PM
Re: no optimization?
1808
June 21, 2006 10:40AM
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.