Re: Subquery performance improvements: When?

[Olaf van der Spek]

xwi_logins: 5,799,457 rows
xwi_players: 189,252 rows

xwi_logins.sid is a key
xwi_players.pid is a unique key

Explain shows DEPENDENT SUBQUERY. Isn't the dependent part wrong?

select pid from xwi_logins where sid = 1139
757 rows in set (1.41 sec)
select distinct pid from xwi_logins where sid = 1139;
6 rows in set (0.01 sec)
select * from xwi_players where pid in (18146,34475,18154,53204,35060,18164);
6 rows in set (0.19 sec)



Edited 2 time(s). Last edit at 02/14/2006 08:33AM by Olaf van der Spek.