-- FULL TABLE ACCESS DT827
--task_id
CREATE INDEX DI008517 ON DT827 (DI008517);/

--costs_total
CREATE INDEX DI008666 ON DT827 (DI008666);/

-- Merged from WI9143
CREATE INDEX I_DT827_COSTS ON DT827
  (
    DI008516 ASC,
    DI008535 ASC,
    DI008518 ASC,
    DI008523 ASC,
    DI008660 ASC,
    DI008661 ASC,
    DI008663 ASC,
    DI008664 ASC,
    DI008665 ASC,
    DI008662 ASC
  )
  NOLOGGING;/

-- DROP INDEX IDX_DT467_EVA_RES_TYPE
CREATE UNIQUE INDEX IDX_DT467_EVA_RES_TYPE ON DT467
  (
    DI001218 ASC, DI003414 ASC, DI001242 ASC
  )
  NOLOGGING;/
