-- Phase 5: indexes for the hottest query paths identified during profiling.
-- Compare EXPLAIN output before/after to verify rows-scanned drops.
CREATE INDEX idx_party_ledger_party_id ON party_ledger (party_id, created_at);
CREATE INDEX idx_order_items_order_id ON order_items (order_id);
CREATE INDEX idx_orders_customer_id ON orders (customer_id, created_at);
CREATE INDEX idx_partner_amperage_ledger_partner_id ON partner_amperage_ledger (partner_id, created_at);
CREATE INDEX idx_otp_codes_mobile_created ON otp_codes (mobile, created_at);
