Index Risk Review
Use this skill for missing-index candidates, plan missing-index warnings, and high-read AX table findings.
Workflow
- Run
scripts/manage_index_governance.py. - Check table family risk using
rules/index_risk_rules.yml. - Validate AX key patterns:
Partition,DataAreaId,RecId, status/date fields. - Produce candidate-review output, not direct
CREATE INDEXinstructions.
Related Scripts
manage_index_governance.pygenerate_validation_scripts.pysimulate_change_risk.py