DevType
Back to list

Rails Migration Index

Lv.3112@mukitaro0 playsJan 2, 2026

CONCURRENTLY creates index without locking writes. Partial index pattern from Rails migrations.

preview.sql
SQL
1CREATE INDEX CONCURRENTLY
2  idx_orders_user_status
3ON orders (
4  user_id,
5  status
6)
7WHERE
8  deleted_at IS NULL;

Custom problems are not included in rankings