>
>set ansi off
>
>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