alter session set db_file_multiblock_read_count=64; 
CREATE INDEX MNP_MSP_TC_IN_I1 ON MNP_MSP_TC_IN
(ID_RICHIESTA_DBC)
LOGGING
TABLESPACE TAB_DWH
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             10M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            FREELISTS        1
            FREELIST GROUPS  1
            BUFFER_POOL      DEFAULT
           )
PARALLEL 5;
alter index MNP_MSP_TC_IN_I1 noparallel;
alter session set db_file_multiblock_read_count=64; 
CREATE INDEX MNP_MVNO_TC_IN_I1 ON MNP_MVNO_TC_IN
(ID_RICHIESTA_DBC)
LOGGING
TABLESPACE TAB_DWH
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            NEXT             10M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            FREELISTS        1
            FREELIST GROUPS  1
            BUFFER_POOL      DEFAULT
           )
PARALLEL 5;
alter index PK_MNP_MVNO_TC_IN  noparallel;