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