In order to improve the performance of the engagement scoring stored procedures, the following indexes have been added:
Table Name |
Index Name |
|---|---|
COM_COMMITTEE_MEMBER |
IX_COM_COMMITTEE_MEMBER_REPRCUST_COMMCUST_POSCODE_BEGINDATE_ENDDATE_PARTICIPATIONCODE |
COM_COMMITTEE_MEMBER |
IX_COM_COMMITTEE_MEMBER_REPRESENTING_ADDDATE_MODDATE |
CUS_CRM360_SQL_JOB_CHRONICLE |
PK_CUS_CRM360_SQL_JOB_CHRONICLE |
CUS_CRM360_SQL_JOB_CHRONICLE |
IX_CUS_CRM360_SQL_JOB_CHRONICLE_CUSTOMER_INCREMENTALCHANGES |
CUS_CRM360_SQL_JOB_CHRONICLE |
IX_CUS_CRM360_SQL_JOB_CHRONICLE_SOCIAL_FLAG |
CUS_CRM360_SQL_JOB_CHRONICLE |
IX_CUS_CRM360_SQL_JOB_CHRONICLE_VOL_FLAG |
CUS_CRM360_SQL_JOB_CHRONICLE |
IX_CUS_CRM360_SQL_JOB_CHRONICLE_ABSTRACT_FLAG |
CUS_CRM360_SQL_JOB_CHRONICLE |
IX_CUS_CRM360_SQL_JOB_CHRONICLE_ORDERFLAG_ROWNUMBER_MCID_SCID |
CUS_INVOLVEMENT_INFO |
IX_CUS_INVOLVEMENT_INFO_UNIQUE_ORG_ORGUNIT_MCID_SCID_RECTYPE_ROWNUM |
CUS_SCORE_ROLLUP_INFO |
PK_CUS_SCORE_ROLLUP_INFO |
CUS_SCORE_ROLLUP_INFO |
CUS_SCORE_ROLLUP_INFO_MASTER_CUSTOMER_ID_SUB_CUSTOMER_ID_IDX |
FAR_TXN |
IX_FAR_TXN_FARTXNO_ORDERNO_TXNDATE_TXNTYPECODE_ACTUALAMOUNT_BASEAMOUNT_ADDDATE_MODDATE |
ORDER_DETAIL |
IX_ORDER_DETAIL_LINESTATUS_CYCLEBEGIN_ORDERNO_ORGID_PRODUCTID_SHIPID_FULFILLCODE_INITIALBEGIN_CYCLEEND_GRACEDATE_RENEWALDATE |
ORDER_DETAIL |
IX_ORDER_DETAIL_ORIG_ORD_NO_LINE_STATUS |
ORDER_DETAIL |
IX_ORDER_DETAIL_ORDERNO_ORDERLINENO_INVOICENO_LINESTATUS_MODDATE |
ORDER_MASTER |
IX_ORDER_MASTER_EMCID_ESCID_ADDDATE_MODDATE |
ORDER_MASTER |
IX_ORDER_MASTER_BILLID_ORGID_ORDERNO |
ORDER_MASTER |
IX_ORDER_MASTER_BILLID_ORDERNO_EMPLOYERID |
The following indexes have been modified from their 7.5.2 version:
Table Name |
Index Name |
|---|---|
ABS_SUBMISSION_REVIEWER |
IX_ABS_SUBMISSION_REVIEWER_CUSTOMERID_SUBCUSTOMERID_ASSIGNMENTSTATUSCODE |
COM_COMMITTEE_MEMBER |
COM_COMMITTEE_MEMBER_MEMB_CUSTOMER_IDX |
CUS_BALANCE_INFO |
PK_CUS_BALANCE_INFO |
CUS_BALANCE_INFO |
CUS_BALANCE_INFO_MASTER_CUSTOMER_ID_SUB_CUSTOMER_ID_ORG_ID_ORG_UNIT_ID_IDX |
CUS_INVOLVEMENT_INFO |
PK_CUS_INVOLVEMENT_INFO |
CUS_SCORE_INFO |
PK_CUS_SCORE_INFO |
CUS_SCORE_INFO |
CUS_SCORE_INFO_MASTER_CUSTOMER_ID_SUB_CUSTOMER_ID_IDX |
CUS_Social_Score |
IX_CUS_Social_Score_MCID_SCID |
ORDER_DETAIL |
ORDDET_ORDERCYCLEDATE_IDX |
The following indexes have been dropped due to being deprecated:
Table Name |
Index Name |
|---|---|
CUS_ORDER_REPORTING_INFO |
IX_CUS_ORDER_REPORTING_INFO_SHIPMCID_SHIPSCID |
CUS_ORDER_REPORTING_INFO |
IX_CUS_ORDER_REPORTING_INFO_BILLMCID_BILLSCID |
CUS_ORDER_REPORTING_INFO |
IX_CUS_ORDER_REPORTING_INFO_LINE_STATUS_CODE |
CUS_ORDER_REPORTING_INFO |
CUS_ORDER_REPORTING_INFO_SUBSYS_BILL_SHIP_CUSTOMER_ORDER_DATE_BASE_TOTAL_IDX |
CUS_ORDER_REPORTING_INFO |
CUS_ORDER_REPORTING_INFO_ORDER_NO_ORDER_LINE_NO_IDX |
CUS_ORDER_REPORTING_INFO |
CUS_ORDER_REPORTING_INFO_CUSTOMER_TYPE_SUBSYS_SHIP_EMPLOYER_CUSTOMER_ORDER_DATE_BASE_TOTAL_IDX |
CUS_ORDER_REPORTING_INFO |
CUS_ORDER_REPORTING_INFO_CUSTOMER_TYPE_SUBSYS_EMPLOYER_MCID_SCID_IDX |
CUS_ORDER_REPORTING_INFO |
CUS_ORDER_REPORTING_INFO_ORG_SUBSYS_PARENT_PRODUCT_ORDER_IDX |
CUS_ORDER_REPORTING_INFO |
CUS_ORDER_REPORTING_INFO_SHIP_MASTER_CUSTOMER_ID_SHIP_SUB_CUSTOMER_ID_ORDER_NO_ORDER_LINE_NO_IDX |
CUS_ORDER_REPORTING_INFO |
IDX_CUS_ORDER_REPORTING_INFO_EMPMAS_EMPSUB_SUBSYSTEM_CUSTYPE |