id |
Primary key |
Asc |
PRIMARY |
date_entered + deleted |
Performance |
Asc/Asc |
idx_favs_date_entered |
record_id + id |
Performance |
Asc/Asc |
idx_favs_id_record_id |
module + record_id + deleted |
Performance |
Asc/Asc/Asc |
idx_favs_module_record_deleted |
modified_user_id + module + deleted |
Performance |
Asc/Asc/Asc |
idx_favs_user_module |
assigned_user_id + deleted |
Performance |
Asc/Asc |
idx_sugarfavorites_assigned_del |
date_entered |
Performance |
Asc |
idx_sugarfavorites_date_entered |
date_modified |
Performance |
Asc |
idx_sugarfavorites_date_modfied |
id + deleted |
Performance |
Asc/Asc |
idx_sugarfavorites_id_del |
name + deleted |
Performance |
Asc/Asc |
idx_sugarfavorites_name_del |