1 DROP INDEX idx_comment_aggregates_hot, idx_comment_aggregates_score;
3 CREATE INDEX idx_comment_aggregates_hot ON comment_aggregates (hot_rank DESC, published DESC);
5 CREATE INDEX idx_comment_aggregates_score ON comment_aggregates (score DESC, published DESC);