--------------------------
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