composite-index

Queries filter on multiple columns: `WHERE status = 'validated' AND trust_score > 0.5 ORDER BY created_at DESC`. Single-column indexes on each column aren't used effectively. Query planner does a full...