Info Mart Indexes
This page provides a comprehensive list of indexes created in a nonpartitioned database, for those tables described in this document. Certain indexes, such as those required for purging, are not created in the schema during database initialization because they are not applicable to a partitioned database. Thus, the number of indexes would be smaller in a partitioned database, where purging is based on partitions.
Legend: U = Unique
| Table | Index | U | Description |
|---|---|---|---|
| Table | Index | U | Description |
| AGENT_LOCATION | I_AGENTLOC_LOCATION | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| BGS_BOT_DIM | I_BGS_BOT_DIM | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| BGS_BOT_NAME_DIM | I_BGS_BOT_NAME_DIM | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| BGS_SESSION_DIM | I_BGS_SESSION_DIM | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| BGS_SESSION_FACT | I_BGS_SESSION_FACT_SDT | Improves access time, based on the Start Date Time key. | |
| BOT_ATTRIBUTES | I_BOT_ATTRIBUTES | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| BOT_INTENT | I_BOT_INTENT | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| CALLBACK_DIAL_RESULTS | I_CALLBACK_DIAL_RESULTS | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| CALLBACK_DIM_1 | I_CALLBACK_DIM_1 | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| CALLBACK_DIM_2 | I_CALLBACK_DIM_2 | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| CALLBACK_DIM_3 | I_CALLBACK_DIM_3 | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| CALLBACK_DIM_4 | I_CALLBACK_DIM_4 | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| CALLING_LIST_METRIC_FACT | I_CLMF_SDT | Improves access time, based on the Start Date Time key. | |
| CALLING_LIST_METRIC_FACT | I_CLMF_TNT | Improves access time, based on the Tenant. | |
| CAMPAIGN_GROUP_SESSION_FACT | I_CGSEF_SID | X | Ensures that the facts that are stored in the table are for unique sessions. |
| CAMPAIGN_GROUP_SESSION_FACT | I_CGSEF_DT | Improves access time, based on the Start Date Time key. | |
| CAMPAIGN_GROUP_SESSION_FACT | I_CGSEF_TNT | Improves access time, based on the Tenant. | |
| CAMPAIGN_GROUP_STATE_FACT | I_CGSTF_STD | Improves access time, based on the Start Date Time key. | |
| CAMPAIGN_GROUP_STATE_FACT | I_CGSTF_CGSF | Improves access time, based on the Campaign Group Session Fact key. | |
| CAMPAIGN_GROUP_STATE_FACT | I_CGSTF_TNT | Improves access time, based on the Tenant. | |
| CDR_DIM1 | I_CDR_DIM1 | X | Reserved for future use. |
| CDR_FACT | I_CDR_FACT_SDT | Reserved for future use. | |
| CHAT_SESSION_DIM | I_CHAT_SESSION_DIM | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| CHAT_SESSION_FACT | I_CHAT_SESSION_FACT_SDT | Improves access time, based on the Start Date Time key. | |
| CHAT_THREAD_FACT | I_CHAT_THREAD_FACT_SDT | Improves access time, based on the Start Date Time key. | |
| COBROWSE_END_REASON | I_COBROWSE_END_REASON | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| COBROWSE_FACT | I_COBROWSE_FACT_SDT | Improves access time, based on the Start Date Time key. | |
| COBROWSE_MODE | I_COBROWSE_MODE | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| COBROWSE_PAGE | I_COBROWSE_PAGE | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| COBROWSE_USER_AGENT | I_COBROWSE_USER_AGENT | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| CONTACT_ATTEMPT_FACT | I_CAF_SDT | Improves access time, based on the Start Date Time key. | |
| CONTACT_ATTEMPT_FACT | I_CAF_TNT | Improves access time, based on the Tenant. | |
| CONTACT_ATTEMPT_FACT | I_CAF_CGSF | Improves access time, based on the Campaign Group Session Fact key. | |
| CONTACT_ATTEMPT_FACT | I_CAF_CID | Improves access time, based on the Call ID. | |
| CTL_AUDIT_LOG | IDX_CTL_AL_CTS | Improves purge performance. | |
| CTL_ETL_HISTORY | I_C_ETL_H_CTS | Improves purge performance. | |
| CTL_EXTRACT_HISTORY | I_C_EXTRACT_H_CTS | Improves purge performance. | |
| CTL_GDPR_HISTORY | I_CTL_GDPR_H_C_ID | Improves search performance. | |
| CTL_GDPR_HISTORY | I_CTL_GDPR_H_CTS | Improves purge performance. | |
| CTL_PURGE_HISTORY | I_C_PURGE_H_CTS | Improves purge performance. | |
| CTL_TRANSFORM_HISTORY | I_C_TRANSFORM_H_CTS | Improves purge performance. | |
| CTL_UDE_KEYS_TO_DIM_MAPPING | I_UDE_KEYS_TO_D_M_KN | X | A constraint that enforces unique mapping for each user-data dimension table. |
| CTL_UD_TO_UDE_MAPPING | I_C_UD_TARGET | X | A constraint that enforces unique mapping for each column in each target user-data table. |
| CTL_UD_TO_UDE_MAPPING | I_C_UD_TO_UDE_KN | Improves access time, based on the user-data key name for mapping that is currently active. | |
| DATE_TIME | IDX_DT_30 | Improves access time, based on a 30-minute key. | |
| DATE_TIME | IDX_DT_NEXT30 | Improves access time, based on the next 30-minute key. | |
| DATE_TIME | IDX_DT_NEXT | Improves access time, based on the key of the next record. | |
| DATE_TIME | IDX_DT_30_INT | Improves access time, based on the 30-minute key, the next 30-minute key, and the primary key. | |
| DATE_TIME | IDX_DT_HOUR_INT | Improves access time, based on the hour key, the next hour key, and the primary key. | |
| DATE_TIME | IDX_DT_DAY_INT | Improves access time, based on the day key, the next day key, and the primary key. | |
| DATE_TIME | IDX_DT_MONTH_INT | Improves access time, based on the month key, the next month key, and the primary key. | |
| DATE_TIME | IDX_DT_CAL_DATE | Improves access time, based on the calendar date. | |
| GPM_DIM1 | I_GPM_DIM1 | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| GPM_FACT | I_GPM_FACT_SDT | Improves access time, based on the Start Date Time key. | |
| GPM_MODEL | I_GPM_MODEL | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| GPM_PREDICTOR | I_GPM_PREDICTOR | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| GPM_RESULT | I_GPM_RESULT | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| GROUP_ANNEX | I_GROUP_ANNEX_END_TS | Improves access time, based on the End Timestamp. | |
| GROUP_ANNEX | I_GROUP_ANNEX | X | Improves access time, based on dimension values. |
| INTERACTION_DESCRIPTOR | I_INTERACTION_DESCRIPTOR | X | Ensures that the combinations of values that are stored in the dimension table for each tenant are unique. |
| INTERACTION_FACT | I_IF_SDT | Improves access time, based on the Start Date Time key. | |
| INTERACTION_FACT | I_IF_CID | Improves access time, based on the Call ID. | |
| INTERACTION_RESOURCE_FACT | I_IRF_SDT | Improves access time, based on the Start Date Time key. | |
| INTERACTION_RESOURCE_FACT | I_IRF_PT_GUID | X | Reserved. |
| INTERACTION_RESOURCE_FACT | IDX_IRF_IID | Improves access time, based on the INTERACTION ID. | |
| IRF_USER_DATA_CUST_1 | I_IRF_USER_DATA_CUST_1_SDT | Improves access time, based on the Start Date Time key. | |
| IRF_USER_DATA_GEN_1 | I_IRF_USER_DATA_GEN_1_SDT | Improves access time, based on the Start Date Time key. | |
| IRF_USER_DATA_KEYS | I_IRF_USER_DATA_KEYS_SDT | Improves access time, based on the Start Date Time key. | |
| IXN_RESOURCE_STATE_FACT | I_IRSF_SDT | Improves access time, based on the Start Date Time key. | |
| LDR_CAMPAIGN | I_LDR_CAMPAIGN | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| LDR_DEVICE | I_LDR_DEVICE | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| LDR_FACT | I_LDR_FACT_SDT | Improves access time, based on the Start Date Time key. | |
| LDR_GROUP | I_LDR_GROUP | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| LDR_LIST | I_LDR_LIST | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| LDR_POSTAL_CODE | I_LDR_POSTAL_CODE | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| LDR_RECORD | I_LDR_RECORD | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| MEDIATION_SEGMENT_FACT | I_MSF_SDT | Improves access time, based on the Start Date Time key. | |
| MEDIATION_SEGMENT_FACT | I_MSF_IID | Improves access time, based on the INTERACTION ID. | |
| MEDIA_ORIGIN | I_MEDIA_ORIGIN | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| MEDIA_TYPE | I_MEDIA_TP_MCD | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| POST_CALL_SURVEY_DIM_1 | I_POST_CALL_SURVEY_DIM_1 | X | Improves access time. |
| POST_CALL_SURVEY_DIM_2 | I_POST_CALL_SURVEY_DIM_2 | X | Improves access time. |
| POST_CALL_SURVEY_DIM_4 | I_POST_CALL_SURVEY_DIM_4 | X | Improves access time. |
| POST_CALL_SURVEY_DIM_5 | I_POST_CALL_SURVEY_DIM_5 | X | Improves access time. |
| POST_CALL_SURVEY_DIM_6 | I_POST_CALL_SURVEY_DIM_6 | X | Improves access time. |
| RESOURCE_ | IDX_RES_CFG_DBID | X | Reserved. |
| RESOURCE_ | IDX_RES_TYPE_CODE | Improves access time, based on the code for the resource type. | |
| RESOURCE_ | I_RES_KEY_CFG_DBID | X | Reserved. |
| RESOURCE_ANNEX | I_RESOURCE_ANNEX | X | Improves access time, based on dimension values. |
| RESOURCE_ANNEX | I_RESOURCE_ANNEX_END_TS | Improves access time, based on the End Timestamp. | |
| SDR_ACTIVITIES_FACT | I_SDR_ACTIVITIES_FACT_SDT | Improves access time, based on the Start Date Time key. | |
| SDR_ACTIVITY | I_SDR_ACTIVITY | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| SDR_APPLICATION | I_SDR_APPLICATION | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| SDR_BOTS_FACT | I_SDR_BOTS_FACT_SDT | Improves access time, based on the Start Date Time key. | |
| SDR_CALL_DISPOSITION | I_SDR_CALL_DISPOSITION | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| SDR_CALL_TYPE | I_SDR_CALL_TYPE | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| SDR_CUST_ATRIBUTES | I_SDR_CUST_ATRIBUTES | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| SDR_CUST_ATRIBUTES_FACT | I_SDR_CUST_ATRIBUTES_FACT_SDT | Improves access time, based on the Start Date Time key. | |
| SDR_ENTRY_POINT | I_SDR_ENTRY_POINT | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| SDR_EXIT_POINT | I_SDR_EXIT_POINT | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| SDR_EXT_HTTP_REST | I_SDR_EXT_HTTP_REST | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| SDR_EXT_REQUEST_FACT | I_SDR_EXT_REQUEST_FACT_SDT | Improves access time, based on the Start Date Time key. | |
| SDR_EXT_REQUEST_OUTCOME | I_SDR_EXT_REQUEST_OUTCOME | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| SDR_EXT_SERVICE_OUTCOME | I_SDR_EXT_SERVICE_OUTCOME | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| SDR_GEO_LOCATION | I_SDR_GEO_LOCATION | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| SDR_INPUT | I_SDR_INPUT | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| SDR_INPUT_OUTCOME | I_SDR_INPUT_OUTCOME | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| SDR_LANGUAGE | I_SDR_LANGUAGE | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| SDR_MESSAGE | I_SDR_MESSAGE | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| SDR_MILESTONE | I_SDR_MILESTONE | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| SDR_SESSION_FACT | I_SDR_SESSION_FACT_SDT | Improves access time, based on the Start Date Time key. | |
| SDR_SURVEY_ANSWERS | I_SDR_SURVEY_ANSWERS | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| SDR_SURVEY_FACT | I_SDR_SURVEY_FACT_SDT | Improves access time, based on the Start Date Time key. | |
| SDR_SURVEY_I1 | I_SDR_SURVEY_I1 | X | Improves access time, based on the CREATE_AUDIT_KEY value. |
| SDR_SURVEY_I2 | I_SDR_SURVEY_I2 | X | Improves access time, based on the CREATE_AUDIT_KEY value. |
| SDR_SURVEY_QUESTIONS | I_SDR_SURVEY_QUESTIONS | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| SDR_SURVEY_QUESTIONS_I1 | I_SDR_SURVEY_QUESTIONS_I1 | X | Improves access time, based on the CREATE_AUDIT_KEY value. |
| SDR_SURVEY_QUESTIONS_I2 | I_SDR_SURVEY_QUESTIONS_I2 | X | Improves access time, based on the CREATE_AUDIT_KEY value. |
| SDR_SURVEY_QUESTIONS_S1 | I_SDR_SURVEY_QUESTIONS_S1 | X | Improves access time, based on the CREATE_AUDIT_KEY value. |
| SDR_SURVEY_QUESTIONS_S2 | I_SDR_SURVEY_QUESTIONS_S2 | X | Improves access time, based on the CREATE_AUDIT_KEY value. |
| SDR_SURVEY_S1 | I_SDR_SURVEY_S1 | X | Improves access time, based on the CREATE_AUDIT_KEY value. |
| SDR_SURVEY_S2 | I_SDR_SURVEY_S2 | X | Improves access time, based on the CREATE_AUDIT_KEY value. |
| SDR_SURVEY_SCORES | I_SDR_SURVEY_SCORES | X | Improves access time, based on the CREATE_AUDIT_KEY value. |
| SDR_SURVEY_STATUS | I_SDR_SURVEY_STATUS | X | Improves access time, based on the CREATE_AUDIT_KEY value. |
| SDR_SURVEY_TRANSCRIPT_FACT | I_SDR_SRV_TRANSCRIPT_FACT_SDT | Improves access time, based on the Start Date Time key. | |
| SDR_USER_INPUT | I_SDR_USER_INPUT | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| SDR_USER_INPUTS_FACT | I_SDR_USER_INPUTS_FACT_SDT | Improves access time, based on the Start Date Time key. | |
| SDR_USER_MILESTONE_FACT | I_SDR_USER_MILESTONE_FACT_SDT | Improves access time, based on the Start Date Time key. | |
| SM_RES_SESSION_FACT | I_SM_RS_SSSN_SDT | Improves access time, based on the Start Date Time key. | |
| SM_RES_STATE_FACT | I_RSSF_SDT | Improves access time, based on the Start Date Time key. | |
| SM_RES_STATE_FACT | I_RSSF_RMESSSR | Improves access time. | |
| SM_RES_STATE_REASON_FACT | I_RSRF_SDT | Improves access time, based on the Start Date Time key. | |
| STG_TRANSFORM_DISCARDS | I_S_TRNFRM_DISCARDS_IXNID | Improves access time, based on the INTERACTION ID. | |
| STG_TRANSFORM_DISCARDS | I_S_TRNFRM_DISCARDS_SDT | Improves access time, based on the ETL_DATE_TIME key. | |
| USER_DATA_CUST_DIM_1 | I_USER_DATA_CUST_DIM_1 | X | Ensures that the combinations of values that are stored in the dimension table are unique. |
| USER_DATA_GEN_DIM_1 | I_USER_DATA_GEN_DIM_1 | X | Reserved for internal use. |
| USER_DATA_GEN_DIM_2 | I_USER_DATA_GEN_DIM_2 | X | Reserved for internal use. |
This page was last edited on June 22, 2022, at 21:02.
Comments or questions about this documentation? Contact us for support!