SQL Practice Logo

SQLPractice Online

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)