Jump to: navigation, search

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 23, 2022, at 00:06.
Comments or questions about this documentation? Contact us for support!