Recommended Database Indices

Field tests have confirmed that creating indices on specific ArcFM enterprise database tables can have a significant impact on efficiency. While these performance gains are especially noticeable for Designer users, most Process Framework installations will experience greater responsiveness with these indices applied to the database.

PX Tables

Index	Table	Fields
MM_PX_CURRENT_STATE_PX1	MM_PX_CURRENT_STATE	SOID,STATE_ID
PX_USER_ROLE_ID_RLID_IDX	MM_PX_USER_ROLE	USER_ID,ROLE_ID
PX_NODE_TYPE_ID_IDX	MM_PX_NODE_TYPE	NODE_TYPE_ID
PX_NODE_TYPE_NAME_IDX	MM_PX_NODE_TYPE	name
PX_FILTERS_PRODID_IDX	MM_PX_FILTERS	progid
PX_STATE_STA_IDX	MM_PX_STATE	STATE
PX_STATE_ROLE_STID_IDX	MM_PX_STATE_ROLE	state_id
PX_SUBTASKS_ID_IDX	MM_PX_SUBTASKS	task_id
PX_SUBTASK_PARAM_STID_IDX	MM_PX_SUBTASKS_PARAMETERS	subtask_id
PX_TRAN_TO_STATE_TRANID_IDX	MM_PX_TRANSITION_TO_STATE	transition_id
PX_TRAN_FROM_STATE_TRANID_IDX	MM_PX_TRANSITION_FROM_STATE	transition_id
PX_TRAN_ROLE_TRANID_IDX	MM_PX_TRANSITION_ROLE	transition_id
PX_HIST_ID_NODETY_NDID_IDX	MM_PX_HISTORY	USER_ID,NODE_TYPE_ID,NODE_ID
MM_MOBILESTATE_NODETYID_IDX	MM_MOBILE_STATE	NODE_TYPE_ID,NODE_ID

WMS Tables

Index	Table	Fields
MM_WMS_DN_COST_FACTOR_IX1	MM_WMS_DN_COST_FACTOR	DESIGN_ID, FACTOR_ID
MM_WMS_CU_COST_FACTOR_CUID_IDX	MM_WMS_CU_COST_FACTOR	CU_ID
MM_WMS_CU_COST_FACTOR_FID_IDX	MM_WMS_CU_COST_FACTOR	FACTOR_ID
MM_WMS_WL_COST_FACTOR_WLID_IDX	MM_WMS_WL_COST_FACTOR	WORKLOCATION_ID
MM_WMS_WL_COST_FACTOR_FID_IDX	MM_WMS_WL_COST_FACTOR	FACTOR_ID
MM_WMS_CU_LIBRARY_IDX	MM_WMS_COMPATIBLE_UNIT_LIBRARY	CODE
MM_WMS_CU_DESIGN_ID_IDX	MM_WMS_COMPATIBLE_UNIT	DESIGN_ID
MM_WMS_CU_WORK_LOC_ID_IDX	MM_WMS_COMPATIBLE_UNIT	WORK_LOCATION_ID
MM_WMS_WORK_LOCATION_IDX	MM_WMS_WORK_LOCATION	DESIGN_ID
MM_WMS_APPROVED_DN_WRID_IDX	MM_WMS_APPROVED_DESIGNS	WORK_REQUEST_ID
MM_WMS_APPROVED_DN_DNID_IDX	MM_WMS_APPROVED_DESIGNS	DESIGN_ID
MM_WMS_DESIGN_COPYFROM_IDX	MM_WMS_DESIGN	COPY_FROM_ID
MM_WMS_WR_USERS_IDX	MM_WMS_WR_USERS	WORK_REQUEST_ID