>

>set ansi off && default
>
>select * ;
>  from abone  ;
>  inner join hurun on abone.hurun  = hurun.id ;
>  inner join ekler on abone.ekler  = ekler.id ;
> where ekler.exp = "Arkd"
>
>

>
>this time query execution time is 6.33 seconds.
>
>
>> Is there a reason you're using Turkish collate. I suggest to use Machine.
>
>At first, I thought this alternetive to solve this problem. But result was same

Ali,
Set deleted is not a concern here, is it?
Cetin