Level 7 - ArchitectQuery-Based Questionsm1 indexing strategy
Composite Index Aligned Queue Fetch
Fetch next 100 pending jobs for tenant 42 ordered by priority desc then created_at asc.
Schema Context
jobs(job_id, tenant_id, status, priority, created_at)