KBD

Keith Devens .com

 Tuesday, December 2, 2008 Flag waving
"Child," said the Voice, "I am telling you your story, not hers. I tell no one any story but his... – C.S. Lewis (The Horse and His Boy, ch 11)
Home » Archive » 2005 » October » 31 » MySQL doesn't use indices for IN subqueries??
← Malcolm Gladwell on Ivy League admissionsThe CRM114 Discriminator - The Controllable Regex Mutilator →

Daily link icon Monday, October 31, 2005

MySQL doesn't use indices for IN subqueries??

Kevin Burton's Feed Blog: What's Next After MySQL 5.0 (via Alex):

This is just insane. In MySQL if you write a subquery like:

SELECT * FROM FOO WHERE ID IN ( SELECT FOO_ID FROM BAR )

IT won't use an index. Fun. Full table scan baby!

Whoa! That's awful.

Chain link icon Permalink | 2 Comments | Tags: linkblog, Programming | id 7521
00:26 (utc-5)
 
← Malcolm Gladwell on Ivy League admissionsThe CRM114 Discriminator - The Controllable Regex Mutilator →

Comments XML gif

Kevin (http://feedblog.org) wrote:

Totally.. very annoying and essentially useless.

∴ Kevin | 31-Oct-2005 4:01am est | http://feedblog.org | #8585

Shantanu Oak (http://oksoft.blogspot.com) wrote:

I have found another issue with "IN".
http://oksoft.blogspot.com/2005/10/mysql-bug.html

∴ Shantanu Oak | 31-Oct-2005 10:48pm est | http://oksoft.blogspot.com | #8594

Feel free to post a comment below. Please see my comment policy.

Formatting Rules (No HTML):

  • **bold**, *italic*, _underlined_, --strikeout--
  • "text"="url" creates a link, and URLs are auto-highlighted
  • Blockquote: Like e-mail, begin paragraph with > (greater-than sign)
  • Lists: begin paragraph with *,-, or + (unordered), or # (ordered)
  • Code block: ?!code:language=perl|php|sql|javascript|etc.{\n}...{\n}?!/code
:
(will be your IP address if blank)
 : (optional)
(Will not be shown on site)
: (optional)
:

December 2008
SunMonTueWedThuFriSat
 123456
78910111213
14151617181920
21222324252627
28293031 



RSS feed RSS feed for Keith's Weblog
Atom feed Atom feed for Keith's Weblog
Weblog archive
Recent comments
  on 6 posts

Recent comments XML

new⇒Perl 6 1.0 in March?

Doh, my mistake. I'm aware of the​relation between Parrot and Rakudo​but I'...

Keith: Dec 2, 1:03am

Free image hosting sites

Well, TinyPic has this in its​FAQ:

> Images and videos is in​your accoun...

Keith: Dec 1, 1:13am

Join a NameValueCollection into a querystring in C#

Well with a lamba expression, this​is what I came up​with:

?!code:csharp...

Gustaf Lindqvist: Nov 30, 4:38pm

Why no generic OrderedDictionary?

Check​http://www.codeproject.com/KB/recip​es/GenericOrderedDictionary.aspx?d...

Gabrielk: Nov 27, 6:57am

WhatIsMyIP.com

http://www.thesysteminfo.com is​another good alternate to​whatismp.com... I...

Kripz: Nov 26, 8:51pm

Girls, please don't get breast implants

Actually I think it's sweet when a​man loves a woman whether she's big​or n...

218.186.12.228: Nov 26, 9:40am

Generated in about 0.245s.

(Used 8 db queries)
 
 
mobile phone