Re: Seriously.. When are we going to get subqueries?!

[Kevin Burton]

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