Lightlines
By jeffallan

sql-pro

jeffallan6k installs

Faster SQL queries, backed by execution plans.

What it does

Improves SQL queries and schema designs with indexing recommendations, execution-plan analysis, and performance measurements.

When to use it

Use for slow queries, complex joins or aggregations, database performance problems, schema design or migration, and query migration between dialects.

How to use it

Give it a SQL implementation or optimization task in your project; it returns optimized queries, index rationale, execution-plan analysis, and before-and-after performance metrics.

What you provide

  • An existing project

Latest review

What you need · 1

Requires a database on which to execute queries and inspect actual execution plans for the verification step.


Access · 1

This skill

database

Write

Creates database indexes