BEGIN;

CREATE INDEX IF NOT EXISTS idx_training_enrollments_source
    ON hr_payroll.employee_training_enrollments (tenant_id, source_type, source_id);

CREATE INDEX IF NOT EXISTS idx_training_enrollments_required_employee
    ON hr_payroll.employee_training_enrollments (tenant_id, employee_id, is_required, completion_status);

CREATE INDEX IF NOT EXISTS idx_training_programs_performance_review
    ON hr_payroll.training_programs (tenant_id, linked_performance_review_id);

CREATE INDEX IF NOT EXISTS idx_training_programs_onboarding_task
    ON hr_payroll.training_programs (tenant_id, linked_onboarding_task_id);

COMMIT;