Level 5 - SeniorMultiple Choice Questions
MCQ: Best Index for Query Pattern
Interviewer prompt: Query is WHERE account_id = ? AND created_at >= ? ORDER BY created_at DESC LIMIT 100. Which index is best?
Interviewer prompt: Query is WHERE account_id = ? AND created_at >= ? ORDER BY created_at DESC LIMIT 100. Which index is best?