Why Distillr for SQL optimization

Distillr is primarily a summarization tool, but its ability to quickly process and analyze text can be applied to SQL optimization tasks. It works best as a lightweight option for initial query review rather than a replacement for specialized SQL tools.

Key strengths

Fast analysis: Distillr can rapidly review SQL queries and flag potential performance issues.
Identifying bad joins: The tool can detect inefficient join patterns and suggest structural changes.
Query refactoring: Distillr can help simplify query logic for better readability.
Web-based access: Easy to use without installation or complex setup.

A realistic example

You inherit a slow query that joins five tables across three schemas. You paste it into Distillr to get a high-level assessment before diving into the query plan. Distillr flags a redundant self-join and suggests removing it. You verify the suggestion against your schema and apply the fix, reducing execution time by 40%.

Pricing and access

Distillr offers a free version with usage limits. The Pro version starts at $4.99 for more extensive use. Check the tool's website for current pricing details.

Alternatives worth considering

SQL Sentry: Provides detailed performance metrics and recommendations for in-depth analysis.
Query Optimizer: Purpose-built for SQL optimization with advanced rewriting features.
DBA Stack: Comprehensive database administration tools including optimization and monitoring.

TL;DR

Use Distillr for quick initial query review when you want a fast second opinion on SQL structure. Skip it if you need detailed performance metrics, execution plans, or advanced optimization features.