"Dmitry Yemanov" <[EMAIL PROTECTED]>
ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:[EMAIL PROTECTED]
>
> ÷ ÓÌÕÞÁÅ (<indexed condition> OR <non-indexed condition>), ÅÓÌÉ
> ÉÎÄÅËÓÉÒÏ×ÁÎÎÏÅ ÕÓÌÏ×ÉÅ FALSE, ÔÏ ÜÔÏ ÎÅ ÇÏ×ÏÒÉÔ ÎÉ Ï ÞÅÍ - ÎÁÍ ÎÕÖÎÁ
ÚÁÐÉÓØ
> ÄÌÑ ×ÙÞÉÓÌÅÎÉÑ ×ÔÏÒÏÇÏ ÐÒÅÄÉËÁÔÁ. îÏ É ÐÒÉ TRUE ÎÁÍ ÎÕÖÎÁ ÜÔÁ ÚÁÐÉÓØ ÄÌÑ
> ÉÔÏÇÏ×ÏÇÏ ÒÅÚÕÌØÔÁÔÁ. ô.Å. × ÌÀÂÏÍ ÓÌÕÞÁÅ ÉÎÄÅËÓÎÙÊ ÓËÁÎ ÄÏÌÖÅÎ ÓÞÉÔÁÔØ
×ÓÅ
> ÚÁÐÉÓÉ ÔÁÂÌÉÃÙ, Á ÜÔÏ ÅÓÔØ ÇÌÕÐÙÊ ÒÁÓÈÏÄ ÒÅÓÕÒÓÏ× - ÄÅÛÅ×ÌÅ ÐÒÏÊÔÉÓØ
> ÎÁÔÕÒÁÌÏÍ.
óÐÁÓÉÂÏ ÚÁ ÐÏÄÒÏÂÎÙÊ ÏÔ×ÅÔ. äÏÌÖÅÎ ÂÙÌ É ÓÁÍ ÄÏÇÁÄÁÔØÓÑ 8-)))
ðÒÉÛÌÏÓØ ÚÁÎÑÔØÓÑ ÐÒÏËÔÏÌÏÇÉÅÊ.
÷ÍÅÓÔÏ
select S.DFM_ID, S.DD, S.SPEED, S.DAYS_COUNT
from Apt_DFM_Speed S
where ((:ADFM_ID = -2147483467) or (S.DFM_ID = :ADFM_ID))
and ((S.DD >= :DD1) or (:DD1 = cast('01.01.01' as date)))
and ((S.CA_LST_ID = :CA_LST_ID) or (:CA_LST_ID = -2147483647))
order by S.DFM_ID, S.DD Desc
(äÁÅÔ PLAN SORT ((S NATURAL)) Execute: 12 125.00 ms)
îÁÐÉÓÁÌ
select S.DFM_ID, S.DD, S.SPEED, S.DAYS_COUNT
from Apt_DFM_Speed S, DFM
where (S.DFM_ID = DFM.ID)
and ((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) or (:CA_LST_ID = -2147483647))
order by S.DFM_ID, S.DD Desc
ðÏÌÕÞÉÌ
PLAN SORT (JOIN (DFM NATURAL,S INDEX (APT_DFM_SPEED_PK)))
Execute : 78.00 ms
ô.Ë. ÜÔÏ ÉÓÐÏÌØÚÕÅÔÓÑ ÄÌÑ ÏÔÞÅÔÏ× É ÐÌÁÎÉÒÏ×ÁÎÉÉ ÚÁËÕÐÏË
(ÌÏÇÉÓÔÉËÁ, ÓËÏÒÏÓÔØ ÒÁÓÈÏÄÁ ÔÏ×ÁÒÁ, etc...),
ÔÏ ×ÒÅÍÑ ËÒÉÔÉÞÎÏ.
12 ÓÅË × ÐÅÒ×ÏÍ ÓÌÕÞÁÅ ÐÒÉ ÐÌÁÎÅ ÎÁÔÕÒÁÌ É
0.078 ÓÅË ×Ï ×ÔÏÒÏÍ ÓÌÕÞÁÅ ÐÒÉ ÉÓÐÏÌØÚÏ×ÁÎÉÉ òë.
ìÉÛÎÉÅ 65 ÔÙÓ. ÞÔÅÎÉÊ ÉÚ DFM (ÓÐÒÁ×ÏÞÎÉË) ÐÒÁËÔÉÞÅÓËÉ ÎÅ ÓËÁÚÙ×ÁÀÔÓÑ.
--
áÒÔÕÒ çÁÌÉÍÏ×. æë æíó (óÏÞÉ).
