Subquery performance improvements: When?
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
Subject
Views
Written By
Posted
Subquery performance improvements: When?
5360
February 08, 2006 10:07AM
2464
February 09, 2006 10:43AM
2475
February 14, 2006 08:31AM
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.