drop index WERTEVAR;
commit;
create unique index WERTEVAR on WERTEVAR (WVTEIL, WVMERKMAL, WVUNTERS, WVWERTNR)
  TABLESPACE qwert_blockindex
  PARALLEL (DEGREE DEFAULT)
;
drop index WVATTRIBUT;
commit;

create index WVATTRIBUT on WERTEVAR (WVATTRIBUT)
  TABLESPACE qwert_blockindex
  PARALLEL (DEGREE DEFAULT)
;
drop index WVCHARGE ;
commit;

create index WVCHARGE on WERTEVAR (WVCHARGE)
  TABLESPACE qwert_blockindex
  PARALLEL (DEGREE DEFAULT)
;
drop index WVDATZEIT ;
commit;

create index WVDATZEIT on WERTEVAR (WVDATZEIT)
  TABLESPACE qwert_blockindex
  PARALLEL (DEGREE DEFAULT)
;
drop index WVMASCHINE ;
commit;

create index WVMASCHINE on WERTEVAR (WVMASCHINE)
  TABLESPACE qwert_blockindex
  PARALLEL (DEGREE DEFAULT)
;
drop index WVMERKMAL ;
commit;

create index WVMERKMAL on WERTEVAR (WVMERKMAL)
  TABLESPACE qwert_blockindex
  PARALLEL (DEGREE DEFAULT)
;
drop index WVNEST ;
commit;

create index WVNEST on WERTEVAR (WVNEST)
  TABLESPACE qwert_blockindex
  PARALLEL (DEGREE DEFAULT)
;
drop index WVPRUEFER ;
commit;

create index WVPRUEFER on WERTEVAR (WVPRUEFER)
  TABLESPACE qwert_blockindex
  PARALLEL (DEGREE DEFAULT)
;
drop index WVPRUEFMIT ;
commit;

create index WVPRUEFMIT on WERTEVAR (WVPRUEFMIT)
  TABLESPACE qwert_blockindex
  PARALLEL (DEGREE DEFAULT)
;
drop index WVAUFTRAG ;
commit;

create index WVAUFTRAG on WERTEVAR (WVAUFTRAG)
  TABLESPACE qwert_blockindex
  PARALLEL (DEGREE DEFAULT)
;
drop index WVDATZEITNEW ;
commit;

create index WVDATZEITNEW on WERTEVAR (WVTEIL,WVMERKMAL,WVUNTERS,WVDATZEIT)
  TABLESPACE qwert_blockindex
  PARALLEL (DEGREE DEFAULT)
;
