MySQL Forums
Forum List  »  Optimizer & Parser

Subquery performance improvements: When?
Posted by: Olaf van der Spek
Date: February 08, 2006 10:07AM

Hi,

The following query takes too long to execute (2 minutes instead of < 1 second).
MySQL considers this a dependent subquery while i think it's an independent subquery.
I know how to rewrite this subquery using only joins, but my question is:
When will this performance issue be fixed?

create table xwi_logins (pid int, sid int);
create table xwi_players (pid int);
select * from xwi_players where pid in (select pid from xwi_logins where sid =
1139);
drop table xwi_logins;
drop table xwi_players;

See also http://bugs.mysql.com/bug.php?id=16159

Greetings,

Olaf

Options: ReplyQuote


Subject
Views
Written By
Posted
Subquery performance improvements: When?
4902
February 08, 2006 10:07AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.