id |
Primary key |
Asc |
PRIMARY |
date_modified |
Performance |
Asc |
idx_tracker_date_modified |
item_id |
Performance |
Asc |
idx_tracker_iid |
monitor_id |
Performance |
Asc |
idx_tracker_monitor_id |
user_id + deleted + visible |
Performance |
Asc/Asc/Asc |
idx_tracker_userid_del_vis |
user_id + item_id + visible |
Performance |
Asc/Asc/Asc |
idx_tracker_userid_itemid_vis |
user_id + visible + id |
Performance |
Asc/Asc/Asc |
idx_tracker_userid_vis_id |
module_name + user_id + date_modified + item_id |
Performance |
Asc/Asc/Asc/Asc |
idx_trckr_mod_uid_dtmod_item |