--------------------------
First query
--------------------------
select * ;
from abone ;
JOIN hurun ON abone.hurun = hurun.id ;
AND hurun.exp like "Merh%" ;
JOIN ekler ON abone.ekler = ekler.id
** Result : selected 309 records in 6.55 seconds
Rushmore optimization level for table abone: none
Rushmore optimization level for table hurun: none
Rushmore optimization level for table ekler: none
Joining table ekler and table abone using index tag Ekler
Joining table hurun and intermediate result using temp index
---------------------------
Second query
---------------------------
select * ;
from abone ;
JOIN ekler on abone.ekler = ekler.id ;
AND ekler.exp like "Arkd%" ;
JOIN hurun ON abone.hurun = hurun.id
** Result : Selected 1155 records in 0.03 seconds
Rushmore optimization level for table abone: none
Rushmore optimization level for table hurun: none
Rushmore optimization level for table ekler: none
Joining table ekler and table abone using index tag Ekler
Joining table hurun and intermediate result using temp index