-- Offline synthetic lab: ordinary CREATE INDEX blocks writes during its build.
-- A production change requires its own approved build/locking strategy.
CREATE INDEX orders_tenant_status_created_id_idx
ON proof.orders (tenant_id, status, created_at DESC, order_id DESC);
