41 lines
1.1 KiB
SQL
41 lines
1.1 KiB
SQL
--Eseguire come utente MNP
|
|
|
|
-- creazione indice su MNP_GESTIONE_RICHIESTA, MNP_GESTIONE_RICHIESTA_REC per performance calcolo numero SIM
|
|
|
|
CREATE INDEX MNP.IDX_GESTIONE_RICHIESTA_REC_10 ON MNP.MNP_GESTIONE_RICHIESTA_REC
|
|
(CODICE_GRUPPO)
|
|
NOLOGGING
|
|
TABLESPACE TAB_IDX_BIG
|
|
PCTFREE 10
|
|
INITRANS 2
|
|
MAXTRANS 255
|
|
STORAGE (
|
|
INITIAL 128M
|
|
NEXT 10M
|
|
MINEXTENTS 1
|
|
MAXEXTENTS 2147483645
|
|
PCTINCREASE 0
|
|
FREELISTS 1
|
|
FREELIST GROUPS 1
|
|
BUFFER_POOL DEFAULT
|
|
)
|
|
NOPARALLEL;
|
|
|
|
CREATE INDEX MNP.IDX_MNP_GESTIONE_RICHIESTA_12 ON MNP.MNP_GESTIONE_RICHIESTA
|
|
(CODICE_GRUPPO)
|
|
NOLOGGING
|
|
TABLESPACE TAB_IDX_BIG
|
|
PCTFREE 10
|
|
INITRANS 2
|
|
MAXTRANS 255
|
|
STORAGE (
|
|
INITIAL 128M
|
|
NEXT 10M
|
|
MINEXTENTS 1
|
|
MAXEXTENTS 2147483645
|
|
PCTINCREASE 0
|
|
FREELISTS 1
|
|
FREELIST GROUPS 1
|
|
BUFFER_POOL DEFAULT
|
|
)
|
|
NOPARALLEL; |