"ArtGal" <[EMAIL PROTECTED]> wrote:
>
>   where ((S.DFM_ID = :ADFM_ID) or (:ADFM_ID = -2147483467))
>     and ((S.DD >= :DD1) or (:DD1 = cast('01.01.01' as date)))
>     and (S.CA_LST_ID = :CA_LST_ID)
>   PLAN SORT ((S INDEX (APT_DFM_SPEED_PK)))

ô×ÏÊ ÐÌÁÎ ÎÅ×ÅÒÅÎ. âÉÔÏ×ÕÀ ËÁÒÔÕ ÄÌÑ OR ÍÏÖÎÏ ÉÓÐÏÌØÚÏ×ÁÔØ ÔÏÌØËÏ ÅÓÌÉ *ÏÂÅ* 
ÞÁÓÔÉ OR ÏÔÏÂÒÁÖÁÀÔÓÑ ÎÁ ÉÎÄÅËÓ. ÷ ÏÔÌÉÞÉÅ ÏÔ AND, ÇÄÅ ÄÏÓÔÁÔÏÞÎÏ ÏÄÎÏÊ 
ÞÁÓÔÉ. ôÁË ÞÔÏ ÕÞÉ ÍÁÔÞÁÓÔØ.


--
äÍÉÔÒÉÊ åÍÁÎÏ×



Ответить