In the last episode (Jun 08), Jeff Smelser said:
> On Tuesday 07 June 2005 04:22 pm, Kevin Burton wrote:
> > Subqueries in 4.1 are totally broken. They don't use indexes.
> > They're evil. We're told we have subqueries but there's no way
> > anyone on earth could use them. To make matters worse a lot of
> > developers are TRICKED into using them and assume that mysql would
> > do the right thing but its a HUGE performance hit.
>
> Well, have you filed a bug? I just looked and didnt see one.. It
> wouldnt be the first time, however, a bug search function didnt find
> something that was there..
There are actually quite a few bugs already filed on subquery
performance: 4975, 7830, 8086, 8414, 9021, 9090, 10309, 10312, 10989,
from a quick search on "+subquery +index". Most have been set to "To
be fixed later".
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
