id |
Primary key |
Asc |
PRIMARY |
assigned_user_id + date_closed_timestamp + deleted |
Performance |
Asc/Asc/Asc |
idx_opp_assigned_timestamp |
deleted + name + date_modified |
Performance |
Asc/Asc/Asc |
idx_opp_name |
acl_team_set_id + deleted |
Performance |
Asc/Asc |
idx_opportunities_acl_tmst_id |
assigned_user_id + deleted |
Performance |
Asc/Asc |
idx_opportunities_assigned_del |
deleted + date_entered + id |
Performance |
Asc/Asc/Asc |
idx_opportunities_del_d_e |
deleted + date_modified + id |
Performance |
Asc/Asc/Asc |
idx_opportunities_del_d_m |
id + deleted |
Performance |
Asc/Asc |
idx_opportunities_id_del |
name + deleted |
Performance |
Asc/Asc |
idx_opportunities_name_del |
team_set_id + deleted |
Performance |
Asc/Asc |
idx_opportunities_tmst_id |
lead_source |
Performance |
Asc |
idx_opportunity_lead_source |
mkto_id |
Performance |
Asc |
idx_opportunity_mkto_id |
deleted + next_step + date_modified |
Performance |
Asc/Asc/Asc |
idx_opportunity_next_step |
opportunity_type |
Performance |
Asc |
idx_opportunity_opportunity_type |
sales_status |
Performance |
Asc |
idx_opportunity_sales_status |