AvoidingfullTablescaninOracle

1  

A few ideas come to mind:

想到一些想法:

1) Define an index on the DD and SYS columns:

1)在DD和SYS列上定义索引:

CREATE INDEX DVCE_TAB_1
  ON DVCE_TAB (DD, SYS);

You'll probably need to gather table statistics after adding indexes:

添加索引后,您可能需要收集表统计信息:

BEGIN
  DBMS_STATS.GATHER_TABLE_STATS(ownname => 'YOUR_SCHEMA_NAME',
                                tabname => 'DVCE_TAB');
END;

That may be all you need, but if needed you can always...

这可能就是您所需要的,但如果需要,您可以随时......

2) Partition DVCE_TAB on the DD column.

2)在DD列上划分DVCE_TAB。

CREATE TABLE DVCE_TAB
  (...column definitions...)
  PARTITION BY RANGE (DD) 
    INTERVAL(NUMTOYMINTERVAL(1, 'MONTH'))
  PARTITION DVCE_TAB_P1 VALUES LESS THAN (TO_DATE('01-01-2000', 'DD-MM-YYYY'))); 

To do this you may need to actually create a new table with a different name, copy all the existing data from the 'old' DVCE_TAB to the 'new' DVCE_TAB, then drop the original table and rename the 'new' table to DVCE_TAB.

为此,您可能需要实际创建一个具有不同名称的新表,将所有现有数据从“旧”DVCE_TAB复制到“新”DVCE_TAB,然后删除原始表并将“新”表重命名为DVCE_TAB。

Best of luck.

祝你好运。