QueryOptimization: indexes.sql

\set ON_ERROR_STOP on
\timing on

CREATE INDEX IF NOT EXISTS idx_cvc_vendor_id ON Client_Vendor_Contract (vendor_id);
CREATE INDEX IF NOT EXISTS idx_cvc_client_id ON Client_Vendor_Contract (client_id);

ANALYZE Client_Vendor_Contract;

\echo 'Indexes present:'
SELECT indexname, indexdef
FROM pg_indexes
WHERE schemaname = 'public' AND indexname LIKE 'idx_%'
ORDER BY indexname;