id |
Primary key |
Asc |
PRIMARY |
|
assigned_user_id + deleted |
Performance |
Asc/Asc |
idx_pmse_bpm_thread_assigned_del |
|
cas_id + deleted |
Performance |
Asc/Asc |
idx_pmse_bpm_thread_del_cas_id |
|
deleted + date_entered + id |
Performance |
Asc/Asc/Asc |
idx_pmse_bpm_thread_del_d_e |
|
deleted + date_modified + id |
Performance |
Asc/Asc/Asc |
idx_pmse_bpm_thread_del_d_m |
|
id + deleted |
Performance |
Asc/Asc |
idx_pmse_bpm_thread_id_del |
|
name + deleted |
Performance |
Asc/Asc |
idx_pmse_bpm_thread_name_del |
|
sync_key |
Must be unique |
Asc |
idx_pmse_bpm_thread_skey |
This unique column is also nullable |