Index Portfolio Optimizer

Optimize the whole index portfolio by finding redundant, overlapping, unused, and high-write-cost indexes.

rweisssieker-xp Updated

File contents

Index Portfolio Optimizer

Run:

node runtime/runTool.js index_portfolio_optimizer '{"indexes":[{"name":"ix_a","columns":["status"],"reads":100,"writes":50},{"name":"ix_ab","columns":["status","created_at"],"reads":200,"writes":60}]}'

Returns redundant indexes, drop candidates, create candidates, and action order.

rweisssieker-xp/sqlserver-postgres-plugin/tree/main/plugins/sqlserver-postgres-performance-advisor/skills/index-portfolio-optimizer commit 133e9cbe01

Frequently asked questions

npx skillmds@latest add rweisssieker-xp/index-portfolio-optimizer