"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, ÇÄÅ ÄÏÓÔÁÔÏÞÎÏ ÏÄÎÏÊ ÞÁÓÔÉ. ôÁË ÞÔÏ ÕÞÉ ÍÁÔÞÁÓÔØ. -- äÍÉÔÒÉÊ åÍÁÎÏ×