🚀 go-pugleaf

Thanks Karol Bieniaszewski

But I use OR, so inner join will not give me the wanted result.

....
or ID in (Select ID From MyTable Where f1 = f2);



"Karol Bieniaszewski" <liviuslivius@poczta.onet.pl> wrote in message 
news:47bd39ef$1@newsgroups.borland.com...
>
> U�ytkownik "Safwan" <safwan_maswadeh@yahoo.com> napisa� w wiadomo�ci 
> news:47bcbe87@newsgroups.borland.com...
>> Hi
>>
>> Select *
>> From MyView
>> Where foo1 = foo2
>> and foo3 = foo4
>> and foo5 = foo6
>> or ID in (Select ID From MyTable Where f1 = f2);
>>
>> With the above statement the speed is acceptable. But when changeing the 
>> same view (MyView) into a store procedure with  - for select .... from 
>> ... do suspend. - like this :
>>
>> Select *
>> From MyStoreProcedure
>> Where foo1 = foo2
>> and foo3 = foo4
>> and foo5 = foo6
>> or ID in (Select ID From MyTable Where f1 = f2);
>>
>> The statement take a looooong time to fetch the records.
>> I use the PLANalyzer to check the statement, I notice that the in clause 
>> cause slow.
>>
>> What should I do to speed up my query ??
>>
> change in (select ..
> to inner join
>
> Karol Bieniaszewski
>
>