✅ 인덱스
posts
CREATE INDEX home_posts_index
ON posts (category_id, state, like_count DESC);
create index category_posts_index on posts(state, created_at desc);
likes
create index likes_index on likes(post_id, user_id);
category
create index category_index on category(category_id, category_type);
✅ 인덱스
posts
create index category_posts_index on posts(state, created_at desc);likes
create index likes_index on likes(post_id, user_id);category
create index category_index on category(category_id, category_type);