éÍÅÅÔÓÑ ÔÁÂÌÉÃÁ
CREATE TABLE APT_DFM_SPEED (
CA_LST_ID INTEGER NOT NULL,
DD DATE NOT NULL,
DFM_ID INTEGER NOT NULL, ...);
/* 2612440 ÚÁÐÉÓÅÊ */
ALTER TABLE APT_DFM_SPEED ADD CONSTRAINT
APT_DFM_SPEED_PK PRIMARY KEY (DFM_ID, DD,
CA_LST_ID);
/* ÓÔÁÔÉÓÔÉËÁ 0.383e-6 */
ALTER TABLE APT_DFM_SPEED ADD CONSTRAINT
APT_DFM_SPEED_CA_LST FOREIGN KEY (CA_LST_ID)
REFERENCES
CA_LST (ID) ON
DELETE CASCADE ON UPDATE CASCADE;
/* ÓÔÁÔÉÓÔÉËÁ 0.786e-4 */
ALTER TABLE APT_DFM_SPEED ADD CONSTRAINT
APT_DFM_SPEED_DFM FOREIGN KEY (DFM_ID) REFERENCES
DFM (ID) ON
DELETE CASCADE ON UPDATE CASCADE;
/* ÓÔÁÔÉÓÔÉËÁ 0.625e-1 */
CREATE INDEX APT_DFM_SPEED_DD_IDX ON
APT_DFM_SPEED (DD);
/* ÓÔÁÔÉÓÔÉËÁ 0.164e-1 */
úÁÐÒÏÓ:
select S.DFM_ID, S.DD, S.SPEED, S.DAYS_COUNT
from Apt_DFM_Speed S
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)))
order by S.DFM_ID, S.DD Desc
Plan
------------------------------------------------
PLAN SORT ((S NATURAL))
Adapted Plan
------------------------------------------------
PLAN SORT ((S NATURAL))
ðÏÞÅÍÕ ÎÁÔÕÒÁÌ? ñ ÖÅ ÐÒÏÓÉÌ PLAN SORT ((S INDEX (APT_DFM_SPEED_PK)))
8-(((
Execute: 10 703.00 ms
Operations Read: 19 847 Writes: 6 Fetches: 5 264 610
Enchanced Info:
Indexed reads 2612440 (Ô.Å. ÷óñ ÔÁÂÌÉÃÁ)
âÅÚ or'Ï× Ya ÄÅÌÁÅÔ ×ÓÅ ËÁË ÄÏÌÖÎÏ É ÂÅÚ Ñ×ÎÏÇÏ ÕËÁÚÁÎÉÑ ÐÌÁÎÁ.
úÁÐÒÏÓ:
select S.DFM_ID, S.DD, S.SPEED, S.DAYS_COUNT
from Apt_DFM_Speed S
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)))
order by S.DFM_ID, S.DD Desc
Plan
------------------------------------------------
PLAN SORT ((S INDEX (APT_DFM_SPEED_PK)))
Adapted Plan
------------------------------------------------
PLAN SORT ((S INDEX (APT_DFM_SPEED_PK)))
Ya ÈÏÒÏÏÏÛÉÊ 8-)))
Execute: 15.00 ms
Operations
------------------------------------------------
Read : 422
Writes : 6
Fetches: 939
÷Ï ×ÔÏÒÏÍ ÓÌÕÞÁÅ ×ÓÅ ÐÒÅËÒÁÓÎÏ.
ëÁË ÏÂÏÊÔÉ ÜÔÉ ÇÒÁÂÌÉ?
--
áÒÔÕÒ çÁÌÉÍÏ×. æë æíó (óÏÞÉ).
