From: Kevin Burton
Date: June 7 2005 10:11pm
Subject: Re: Seriously..  When are we going to get subqueries?!
List-Archive: http://lists.mysql.com/mysql/185139
Message-Id: <42A61B74.3080204@rojo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Greg Whalin wrote:

> They do use indexes if you use them to build derived tables and are 
> pretty fast.  The only case where I see them not using indexes when I 
> think they should is when you use a sub-query for an IN() clause.

I'm sorry.. yes.. They're not using indexes when within IN clauses which 
for me is 99.9% of the time.

Maybe I'm wrong though and this is a rare but I don't think so...

Kevin

-- 


Use Rojo (RSS/Atom aggregator)! - visit http://rojo.com. 
See irc.freenode.net #rojo if you want to chat.

Rojo is Hiring! - http://www.rojonetworks.com/JobsAtRojo.html

   Kevin A. Burton, Location - San Francisco, CA
      AIM/YIM - sfburtonator,  Web - http://peerfear.org/
GPG fingerprint: 5FB2 F3E2 760E 70A8 6174 D393 E84D 8D04 99F1 4412