Re: no optimization?
Posted by:
Apachez
Date: June 18, 2006 08:50PM
I think that is part of a "feature" named "row-subquery":
http://dev.mysql.com/doc/refman/5.0/en/row-subqueries.html
I guess best would be if you posted that as a bug in the optimizer because as you said if there is an index which can be used it should be used, specially when you force it with FORCE INDEX() in the query.
Subject
Views
Written By
Posted
2508
May 22, 2006 05:47AM
Re: no optimization?
1852
June 18, 2006 08:50PM
1819
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.