49 lines
1.3 KiB
SQL
49 lines
1.3 KiB
SQL
CREATE INDEX MNP.IDX_MNP_GISP_RETRIEVE_OUT_2 ON MNP.MNP_GISP_RETRIEVE_OUT
|
|
(ID_RICHIESTA)
|
|
NOLOGGING
|
|
TABLESPACE TAB_IDX_HUGE_2_2
|
|
PCTFREE 10
|
|
INITRANS 2
|
|
MAXTRANS 255
|
|
STORAGE (
|
|
INITIAL 512 M
|
|
NEXT 256 M
|
|
MINEXTENTS 1
|
|
MAXEXTENTS UNLIMITED
|
|
PCTINCREASE 0
|
|
BUFFER_POOL DEFAULT
|
|
) ONLINE
|
|
PARALLEL 4;
|
|
ALTER INDEX MNP.IDX_MNP_GISP_RETRIEVE_OUT_2 NOPARALLEL;
|
|
CREATE INDEX MNP.IDX_MNP_GESTIONE_RICHIESTA_8 ON MNP.MNP_GESTIONE_RICHIESTA
|
|
(ADDIZIONALE_1)
|
|
NOLOGGING
|
|
TABLESPACE TAB_IDX_HUGE_2_2
|
|
PCTFREE 10
|
|
INITRANS 2
|
|
MAXTRANS 255
|
|
STORAGE (
|
|
INITIAL 128 M
|
|
NEXT 128 M
|
|
MINEXTENTS 1
|
|
MAXEXTENTS UNLIMITED
|
|
PCTINCREASE 0
|
|
BUFFER_POOL DEFAULT
|
|
)
|
|
NOPARALLEL;
|
|
CREATE INDEX MNP.IDX_MNP_GESTIONE_RICHIESTA_9 ON MNP.MNP_GESTIONE_RICHIESTA
|
|
(ADDIZIONALE_2)
|
|
NOLOGGING
|
|
TABLESPACE TAB_IDX_HUGE_2_2
|
|
PCTFREE 10
|
|
INITRANS 2
|
|
MAXTRANS 255
|
|
STORAGE (
|
|
INITIAL 128 M
|
|
NEXT 128 M
|
|
MINEXTENTS 1
|
|
MAXEXTENTS UNLIMITED
|
|
PCTINCREASE 0
|
|
BUFFER_POOL DEFAULT
|
|
)
|
|
NOPARALLEL; |