Database Indices

You will notice significant performance gains in opening and saving designs if you create the following indices on the PX tables in your database:

SQL Index Statements

Copy Code

create index PX_USER_USERID_IDX on PROCESS.MM_PX_USER(USER_ID);
create index PX_USER_ROLE_ID_RLID_IDX on PROCESS.MM_PX_USER_ROLE(USER_ID,ROLE_ID);
create index PX_ROLE_RLID_IDX on PROCESS.MM_PX_ROLE(ROLE_ID);
create index PX_NODE_TYPE_ID_IDX on PROCESS.MM_PX_NODE_TYPE(NODE_TYPE_ID);
create index PX_NODE_TYPE_NAME_IDX on PROCESS.MM_PX_NODE_TYPE(name);
create index PX_FILTERS_PRODID_IDX on PROCESS.MM_PX_FILTERS(progid);
create index PX_STATE_STID_IDX on PROCESS.MM_PX_STATE(STATE_ID);
create index PX_STATE_STA_IDX on PROCESS.MM_PX_STATE(STATE);
create index PX_STATE_ROLE_STID_IDX on PROCESS.MM_PX_STATE_ROLE(state_id);
create index PX_SUBTASKS_ID_IDX on PROCESS.MM_PX_SUBTASKS(task_id);
create index PX_SUBTASK_PARAM_STID_IDX on PROCESS.MM_PX_SUBTASKS_PARAMETERS(subtask_id);
create index PX_TRAN_TO_STATE_TRANID_IDX on PROCESS.MM_PX_TRANSITION_TO_STATE(transition_id);
create index PX_TRAN_FROM_STATE_TRANID_IDX on PROCESS.MM_PX_TRANSITION_FROM_STATE(transition_id);
create index PX_TRAN_ROLE_TRANID_IDX on PROCESS.MM_PX_TRANSITION_ROLE(transition_id);
create index PX_HIST_ID_NODETY_NDID_IDX on PROCESS.MM_PX_HISTORY(USER_ID,NODE_TYPE_ID,NODE_ID); 
create index MM_MOBILESTATE_NODETYID_IDX on PROCESS.MM_MOBILE_STATE(NODE_TYPE_ID,NODE_ID);