Lightlines
By jeffallan

database-optimizer

jeffallan5.5k installs

Faster database queries, with measured results.

What it does

Improves database performance with measured query, index, schema, and configuration changes.

When to use it

Use for slow-query analysis, index design, configuration tuning, schema and partitioning optimization, lock contention, or cache and memory performance.

How to use it

Give it a database performance problem; it returns baseline analysis, identified bottlenecks, implementation SQL or configuration changes, and validation queries.

Good to know

  • cannot be undone: database

Latest review

What you need · 1

Requires database access to capture metrics and run execution plans, with a non-production environment for testing changes first.


Access · 1

This skill

database

Write

Creates and removes database indexes (irreversible)