SQL Practice Logo

SQLPractice Online

Level 7 - ArchitectQuery-Based Questionsm1 indexing strategy

Index-Only Candidate for Comment Feed

Return latest 30 approved comments for post_id=900 with comment_id, author_id, created_at.

Schema Context

comments(comment_id, post_id, status, author_id, created_at, body)