-- looks routine in review, locks your table in production:

CREATE INDEX idx_orders_customer ON orders (customer_id);

ALTER TABLE users ALTER COLUMN email SET NOT NULL;

Enter fullscreen mode

Exit fullscreen mode