id |
Primary key |
Asc |
PRIMARY |
assigned_user_id + deleted |
Performance |
Asc/Asc |
idx_pmse_bpm_flow_assigned_del |
bpmn_type + cas_flow_status + cas_due_date + deleted |
Performance |
Asc/Asc/Asc/Asc |
idx_pmse_bpm_flow_bpmn_type_flow_status_due_date_del |
bpmn_id + cas_flow_status |
Performance |
Asc/Asc |
idx_pmse_bpm_flow_cas_flow_status |
cas_id |
Performance |
Asc |
idx_pmse_bpm_flow_cas_id |
cas_id + cas_flow_status |
Performance |
Asc/Asc |
idx_pmse_bpm_flow_cas_id_flow_status |
cas_sugar_object_id |
Performance |
Asc |
idx_pmse_bpm_flow_cas_sugar_object_id |
date_entered |
Performance |
Asc |
idx_pmse_bpm_flow_date_entered |
date_modified |
Performance |
Asc |
idx_pmse_bpm_flow_date_modfied |
cas_id + deleted |
Performance |
Asc/Asc |
idx_pmse_bpm_flow_del_cas_id |
id + deleted |
Performance |
Asc/Asc |
idx_pmse_bpm_flow_id_del |
name + deleted |
Performance |
Asc/Asc |
idx_pmse_bpm_flow_name_del |
cas_sugar_object_id + cas_sugar_module |
Performance |
Asc/Asc |
idx_pmse_bpm_flow_parent |
cas_sugar_object_id + cas_sugar_module + cas_index |
Performance |
Asc/Asc/Asc |
idx_pmse_bpm_flow_parent_and_cas_id |
cas_flow_status |
Performance |
Asc |
idx_pmse_bpm_flow_status |