Level 7 - ArchitectMultiple Choice Questionsm1 indexing strategy
MCQ: Best Composite Index for Recent Paid Orders
Which index best supports WHERE status='PAID' AND created_at >= ? ORDER BY created_at DESC LIMIT 50 ?
Which index best supports WHERE status='PAID' AND created_at >= ? ORDER BY created_at DESC LIMIT 50 ?