MySQL Forums
Forum List  »  Optimizer & Parser

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

Options: ReplyQuote


Subject
Views
Written By
Posted
2490
Uwe
May 22, 2006 05:47AM
1842
June 18, 2006 08:50PM
Re: no optimization?
1808
Uwe
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.