cphillips83 · March 16, 2026 20:51
diff --git a/hotfix-orders-status.sql b/hotfix-orders-status.sql
 -- Fix: add missing index on orders.status for active order queries
 -- Author: DBA Team
 -- Date: 2026-03-16

 BEGIN;

 CREATE INDEX CONCURRENTLY idx_orders_status 
 ON orders(status) 
 WHERE status != 'completed';

 -- Verify
 SELECT indexname, indexdef 
 FROM pg_indexes 
 WHERE tablename = 'orders' AND indexname = 'idx_orders_status';

 COMMIT;
	-- Fix: add missing index on orders.status for active order queries
	-- Author: DBA Team
	-- Date: 2026-03-16

	BEGIN;

	CREATE INDEX CONCURRENTLY idx_orders_status
	ON orders(status)
	WHERE status != 'completed';

	-- Verify
	SELECT indexname, indexdef
	FROM pg_indexes
	WHERE tablename = 'orders' AND indexname = 'idx_orders_status';

	COMMIT;
No results found