List: | General Discussion | « Previous MessageNext Message » | |
From: | Kevin Burton | Date: | June 7 2005 10:11pm |
Subject: | Re: Seriously.. When are we going to get subqueries?! | ||
View as plain text |
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