141 lines
7.0 KiB
SQL
141 lines
7.0 KiB
SQL
|
|
spool rebuildIndex_200910.log;
|
|
|
|
ALTER INDEX PK_BIT_OUT_REC REBUILD PARALLEL ;
|
|
ALTER INDEX PK_BIT_OUT_REC NOPARALLEL ;
|
|
ALTER INDEX IDX_MNP_BIT_OUT_REC_1 REBUILD PARALLEL 4 ;
|
|
ALTER INDEX IDX_MNP_BIT_OUT_REC_1 NOPARALLEL;
|
|
ALTER INDEX IDX_MNP_BIT_OUT_REC REBUILD PARALLEL 4 ;
|
|
ALTER INDEX IDX_MNP_BIT_OUT_REC NOPARALLEL;
|
|
ALTER INDEX PK_CCRM_NOTIFICA_OUT REBUILD PARALLEL 4 ;
|
|
ALTER INDEX PK_CCRM_NOTIFICA_OUT NOPARALLEL;
|
|
ALTER INDEX MNP_CCRM_NOTIFICA_OUT_2 REBUILD PARALLEL 4 ;
|
|
ALTER INDEX MNP_CCRM_NOTIFICA_OUT_2 NOPARALLEL;
|
|
ALTER INDEX IDX_CCRM_NOTIFICA_OUT_3 REBUILD PARALLEL 4 ;
|
|
ALTER INDEX IDX_CCRM_NOTIFICA_OUT_3 NOPARALLEL;
|
|
ALTER INDEX IDX_MNP_CIRCE_OUT_1 REBUILD PARALLEL 4 ;
|
|
ALTER INDEX IDX_MNP_CIRCE_OUT_1 NOPARALLEL;
|
|
ALTER INDEX PK_CIRCE_OUT REBUILD PARALLEL 4 ;
|
|
ALTER INDEX PK_CIRCE_OUT NOPARALLEL;
|
|
ALTER INDEX PK_CIRCE_OUT_REC REBUILD PARALLEL 4 ;
|
|
ALTER INDEX PK_CIRCE_OUT_REC NOPARALLEL;
|
|
ALTER INDEX IDX_MNP_CIRCE_OUT_REC_1 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_MNP_CIRCE_OUT_REC_1 NOPARALLEL;
|
|
ALTER INDEX PK_CRM_VALIDAZIONE_IN REBUILD PARALLEL 4;
|
|
ALTER INDEX PK_CRM_VALIDAZIONE_IN NOPARALLEL;
|
|
ALTER INDEX IDX_MNP_CRM_VALIDAZIONE_IN_2 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_MNP_CRM_VALIDAZIONE_IN_2 NOPARALLEL;
|
|
ALTER INDEX IDX_MNP_CRM_VALIDAZIONE_IN_1 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_MNP_CRM_VALIDAZIONE_IN_1 NOPARALLEL;
|
|
ALTER INDEX PK_CRM_VALIDAZIONE_OUT REBUILD PARALLEL 4;
|
|
ALTER INDEX PK_CRM_VALIDAZIONE_OUT NOPARALLEL;
|
|
ALTER INDEX IDX_MNP_CRM_VALIDAZIONE_OUT_3 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_MNP_CRM_VALIDAZIONE_OUT_3 NOPARALLEL;
|
|
ALTER INDEX IDX_MNP_CRM_VALIDAZIONE_OUT_2 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_MNP_CRM_VALIDAZIONE_OUT_2 NOPARALLEL;
|
|
ALTER INDEX IDX_MNP_CRM_VALIDAZIONE_OUT_1 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_MNP_CRM_VALIDAZIONE_OUT_1 NOPARALLEL;
|
|
ALTER INDEX PK_GESTIONE_RICHIESTA REBUILD PARALLEL 4;
|
|
ALTER INDEX PK_GESTIONE_RICHIESTA NOPARALLEL;
|
|
ALTER INDEX IDX_MNP_GESTIONE_RICHIESTA_7 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_MNP_GESTIONE_RICHIESTA_7 NOPARALLEL;
|
|
ALTER INDEX IDX_MNP_GESTIONE_RICHIESTA_6 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_MNP_GESTIONE_RICHIESTA_6 NOPARALLEL;
|
|
ALTER INDEX IDX_MNP_GESTIONE_RICHIESTA_5 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_MNP_GESTIONE_RICHIESTA_5 NOPARALLEL;
|
|
ALTER INDEX IDX_MNP_GESTIONE_RICHIESTA_4 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_MNP_GESTIONE_RICHIESTA_4 NOPARALLEL;
|
|
ALTER INDEX IDX_MNP_GESTIONE_RICHIESTA_3 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_MNP_GESTIONE_RICHIESTA_3 NOPARALLEL;
|
|
ALTER INDEX IDX_MNP_GESTIONE_RICHIESTA_2 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_MNP_GESTIONE_RICHIESTA_2 NOPARALLEL;
|
|
ALTER INDEX IDX_MNP_GESTIONE_RICHIESTA_1 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_MNP_GESTIONE_RICHIESTA_1 NOPARALLEL;
|
|
ALTER INDEX PK_GESTIONE_RICHIESTA_REC REBUILD PARALLEL 4;
|
|
ALTER INDEX PK_GESTIONE_RICHIESTA_REC NOPARALLEL;
|
|
ALTER INDEX IDX_GESTIONE_RICHIESTA_REC_8 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_GESTIONE_RICHIESTA_REC_8 NOPARALLEL;
|
|
ALTER INDEX IDX_GESTIONE_RICHIESTA_REC_7 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_GESTIONE_RICHIESTA_REC_7 NOPARALLEL;
|
|
ALTER INDEX IDX_GESTIONE_RICHIESTA_REC_6 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_GESTIONE_RICHIESTA_REC_6 NOPARALLEL;
|
|
ALTER INDEX IDX_GESTIONE_RICHIESTA_REC_4 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_GESTIONE_RICHIESTA_REC_4 NOPARALLEL;
|
|
ALTER INDEX IDX_GESTIONE_RICHIESTA_REC_3 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_GESTIONE_RICHIESTA_REC_3 NOPARALLEL;
|
|
ALTER INDEX IDX_GESTIONE_RICHIESTA_REC_2 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_GESTIONE_RICHIESTA_REC_2 NOPARALLEL;
|
|
ALTER INDEX IDX_GESTIONE_RICHIESTA_REC_1 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_GESTIONE_RICHIESTA_REC_1 NOPARALLEL;
|
|
ALTER INDEX PK_STORICO_PORTING REBUILD PARALLEL 4;
|
|
ALTER INDEX PK_STORICO_PORTING NOPARALLEL;
|
|
ALTER INDEX IDX_STORICO_PORTING_1 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_STORICO_PORTING_1 NOPARALLEL;
|
|
ALTER INDEX PK_STORICO_RICHIESTA REBUILD PARALLEL 4;
|
|
ALTER INDEX PK_STORICO_RICHIESTA NOPARALLEL;
|
|
ALTER INDEX IDX_MNP_STORICO_RICHIESTA_3 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_MNP_STORICO_RICHIESTA_3 NOPARALLEL;
|
|
ALTER INDEX IDX_MNP_STORICO_RICHIESTA_2 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_MNP_STORICO_RICHIESTA_2 NOPARALLEL;
|
|
ALTER INDEX IDX_MNP_STORICO_RICHIESTA_1 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_MNP_STORICO_RICHIESTA_1 NOPARALLEL;
|
|
ALTER INDEX PK_STORICO_RICHIESTA_REC REBUILD PARALLEL 4;
|
|
ALTER INDEX PK_STORICO_RICHIESTA_REC NOPARALLEL;
|
|
ALTER INDEX IDX_STORICO_RICHIESTA_REC_2 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_STORICO_RICHIESTA_REC_2 NOPARALLEL;
|
|
ALTER INDEX IDX_STORICO_RICHIESTA_REC_1 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_STORICO_RICHIESTA_REC_1 NOPARALLEL;
|
|
ALTER INDEX IDX_XML_IN_1 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_XML_IN_1 NOPARALLEL;
|
|
ALTER INDEX PK_XML_IN REBUILD PARALLEL 4;
|
|
ALTER INDEX PK_XML_IN NOPARALLEL;
|
|
ALTER INDEX PK_XML_OUT REBUILD PARALLEL 4;
|
|
ALTER INDEX PK_XML_OUT NOPARALLEL;
|
|
ALTER INDEX IDX_MNP_XML_OUT_2 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_MNP_XML_OUT_2 NOPARALLEL;
|
|
ALTER INDEX IDX_MNP_XML_OUT_1 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_MNP_XML_OUT_1 NOPARALLEL;
|
|
ALTER INDEX PK_XML_RICHIESTA_IN REBUILD PARALLEL 4;
|
|
ALTER INDEX PK_XML_RICHIESTA_IN NOPARALLEL;
|
|
ALTER INDEX IDX_MNP_XML_RICHIESTA_IN_2 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_MNP_XML_RICHIESTA_IN_2 NOPARALLEL;
|
|
ALTER INDEX IDX_MNP_XML_RICHIESTA_IN_1 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_MNP_XML_RICHIESTA_IN_1 NOPARALLEL;
|
|
ALTER INDEX PK_XML_RICHIESTA_OUT REBUILD PARALLEL 4;
|
|
ALTER INDEX PK_XML_RICHIESTA_OUT NOPARALLEL;
|
|
ALTER INDEX IDX_MNP_XML_RICHIESTA_OUT_2 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_MNP_XML_RICHIESTA_OUT_2 NOPARALLEL;
|
|
ALTER INDEX IDX_MNP_XML_RICHIESTA_OUT_1 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_MNP_XML_RICHIESTA_OUT_1 NOPARALLEL;
|
|
ALTER INDEX PK_CCRMW_COOP_NOTIFICA_OUT REBUILD PARALLEL 4;
|
|
ALTER INDEX PK_CCRMW_COOP_NOTIFICA_OUT NOPARALLEL;
|
|
ALTER INDEX MNP_CCRMW_COOP_NOTIFICA_OUT_2 REBUILD PARALLEL 4;
|
|
ALTER INDEX MNP_CCRMW_COOP_NOTIFICA_OUT_2 NOPARALLEL;
|
|
ALTER INDEX IDX_CCRMW_COOP_NOTIFICA_OUT_3 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_CCRMW_COOP_NOTIFICA_OUT_3 NOPARALLEL;
|
|
ALTER INDEX PK_MNP_GEST_RICH_REC_VIRT REBUILD PARALLEL 4;
|
|
ALTER INDEX PK_MNP_GEST_RICH_REC_VIRT NOPARALLEL;
|
|
ALTER INDEX IDX_MNP_GEST_RICH_REC_VIRT1 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_MNP_GEST_RICH_REC_VIRT1 NOPARALLEL;
|
|
ALTER INDEX PK_MNP_STORICO_RICH_REC_VIRT REBUILD PARALLEL 4;
|
|
ALTER INDEX PK_MNP_STORICO_RICH_REC_VIRT NOPARALLEL;
|
|
ALTER INDEX IDX_MNP_STORICO_RICH_REC_VIRT2 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_MNP_STORICO_RICH_REC_VIRT2 NOPARALLEL;
|
|
ALTER INDEX IDX_MNP_STORICO_RICH_REC_VIRT1 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_MNP_STORICO_RICH_REC_VIRT1 NOPARALLEL;
|
|
ALTER INDEX PK_MNP_GEST_RICH_DONOR_VIRT REBUILD PARALLEL 4;
|
|
ALTER INDEX PK_MNP_GEST_RICH_DONOR_VIRT NOPARALLEL;
|
|
ALTER INDEX IDX_MNP_GEST_RICH_DON_VIRT_2 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_MNP_GEST_RICH_DON_VIRT_2 NOPARALLEL;
|
|
ALTER INDEX IDX_MNP_GEST_RICH_DONOR_VIRT1 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_MNP_GEST_RICH_DONOR_VIRT1 NOPARALLEL;
|
|
ALTER INDEX PK_MNP_STORICO_RICH_DON_VIRT REBUILD PARALLEL 4;
|
|
ALTER INDEX PK_MNP_STORICO_RICH_DON_VIRT NOPARALLEL;
|
|
ALTER INDEX IDX_MNP_STORICO_RICH_DON_VIRT2 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_MNP_STORICO_RICH_DON_VIRT2 NOPARALLEL;
|
|
ALTER INDEX IDX_MNP_STORICO_RICH_DON_VIRT1 REBUILD PARALLEL 4;
|
|
ALTER INDEX IDX_MNP_STORICO_RICH_DON_VIRT1 NOPARALLEL;
|
|
|
|
spool off;
|
|
|