alter session set db_file_multiblock_read_count=64;
CREATE INDEX 	DBCGO.IDX25_DBCGO_GESTIONE_RIC_REC ON DBCGO.DBCGO_GESTIONE_RICHIESTA_REC
(CODICE_GRUPPO)
NOLOGGING
TABLESPACE DBCGO_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
           )
PARALLEL 5;
alter index  DBCGO.IDX25_DBCGO_GESTIONE_RIC_REC noparallel;