alter table fave
drop index fave_user_id_idx,
add index fave_user_id_idx (user_id,modified);
+
+alter table subscription
+ drop index subscription_subscriber_idx,
+ add index subscription_subscriber_idx (subscriber,created),
+ drop index subscription_subscribed_idx,
+ add index subscription_subscribed_idx (subscribed,created);
+
+alter table notice
+ drop index notice_profile_id_idx,
+ add index notice_profile_id_idx (profile_id,created,id);