|
DROP INDEX idx_comment_aggregates_hot, idx_comment_aggregates_score;
|
|
|
|
CREATE INDEX idx_comment_aggregates_hot ON comment_aggregates (hot_rank DESC, published DESC);
|
|
|
|
CREATE INDEX idx_comment_aggregates_score ON comment_aggregates (score DESC, published DESC);
|
|
|