2 ms·
> CREATE INDEX idx_dlq_status ON dlq_events (status); > CREATE INDEX idx_dlq_status_retry_after ON dlq_events (status, retry_after); You don't need two indice
by deepsun 8mo ago
> CREATE INDEX idx_dlq_status ON dlq_events (status);
> CREATE INDEX idx_dlq_status_retry_after ON dlq_events (status, retry_after);
You don't need two indices when one is a prefix of another. Just one `idx_dlq_status_retry_after` will do the job.