CREATE INDEX idx_sup_risk ON dim_suppliers(risk_band); CREATE INDEX idx_sup_category ON dim_suppliers(category); ...