Level 5 - SeniorQuery-Based Questions
Create Covering Index for Ticket Search
Interviewer prompt: Query fetches open tickets by assignee ordered by updated_at, selecting ticket_id and priority. Write index DDL that best supports this pattern.
Schema Context
tickets(ticket_id, assignee_id, status, priority, updated_at)