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:

Index Name

Table

Fields

PX_USER_USERID_IDX

PROCESS.MM_PX_USER

USER_ID

PX_USER_ROLE_ID_RLID_IDX

PROCESS.MM_PX_USER_ROLE

USER_ID,ROLE_ID

PX_ROLE_RLID_IDX

PROCESS.MM_PX_ROLE

ROLE_ID

PX_NODE_TYPE_ID_IDX

PROCESS.MM_PX_NODE_TYPE

NODE_TYPE_ID

PX_NODE_TYPE_NAME_IDX

PROCESS.MM_PX_NODE_TYPE

name

PX_FILTERS_PRODID_IDX

PROCESS.MM_PX_FILTERS

progid

PX_STATE_STID_IDX

PROCESS.MM_PX_STATE

STATE_ID

PX_STATE_STA_IDX

PROCESS.MM_PX_STATE

STATE

PX_STATE_ROLE_STID_IDX

PROCESS.MM_PX_STATE_ROLE

state_id

PX_SUBTASKS_ID_IDX

PROCESS.MM_PX_SUBTASKS

task_id

PX_SUBTASK_PARAM_STID_IDX

PROCESS.MM_PX_SUBTASKS_PARAMETERS

subtask_id

PX_TRAN_TO_STATE_TRANID_IDX

PROCESS.MM_PX_TRANSITION_TO_STATE

transition_id

PX_TRAN_FROM_STATE_TRANID_IDX

PROCESS.MM_PX_TRANSITION_FROM_STATE

transition_id

PX_TRAN_ROLE_TRANID_IDX

PROCESS.MM_PX_TRANSITION_ROLE

transition_id

PX_HIST_ID_NODETY_NDID_IDX

PROCESS.MM_PX_HISTORY

USER_ID,NODE_TYPE_ID,NODE_ID

MM_MOBILESTATE_NODETYID_IDX

PROCESS.MM_MOBILE_STATE

NODE_TYPE_ID,NODE_ID

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);
QR code for this page

Was this helpful?