🚀 go-pugleaf

then try exists clause

Select *
From MyStoreProcedure MSP
Where MSP.foo1 = MSP.foo2
and MSP.foo3 = MSP.foo4
and MSP.foo5 = MSP.foo6
or exists(SELECT * FROM MyTable MT where MT.ID=MSP.ID AND MT.f1=MT.f2)

Karol Bieniaszewski



U�ytkownik "Safwan" <safwan_maswadeh@yahoo.com> napisa� w wiadomo�ci 
news:47bd3ecc$1@newsgroups.borland.com...
> 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
>>
>>
>
>