BITMAP执行计划

UPDATE mm_kanban_middle
SET     uploadflg    =:1,
        expremark    =:2,
        chuser       =:3,
        chtime       =:4
WHERE   reqid        =:5
        AND fccode   =:6
        AND plcode   =:7
        AND reqseq   =:8
        AND state    =:9
        AND uploadflg='0'

 

在此过程中创建了以

create index IDX_MM_KANBAN_MIDDLE on MM_KANBAN_MIDDLE (REQID)
  tablespace MES
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
create index INX_MM_KANBAN_MIDDLE on MM_KANBAN_MIDDLE (REQSEQ)
  tablespace MES
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

 

 

查看执行计划