SQL Query Optimizer

NEW

Find and fix SQL performance issues

FreeNo sign-upDeveloper Tools →

SQL Query Optimizer scans a query for well-known performance anti-patterns and lists recommendations. Checks include SELECT *, a leading wildcard in LIKE, functions wrapped around columns in WHERE, missing WHERE or LIMIT clauses, and OR conditions that can block index use.

It is a static, rule-based review of the query text. It cannot see your tables, indexes or row counts, so treat its findings as a checklist to confirm with your database's EXPLAIN output.

Advertisement

How to use SQL Query Optimizer

1

Paste a query

Add the statement to review.

2

Run the analysis

Findings and suggestions are listed.

3

Verify with EXPLAIN

Confirm each suggestion against the real execution plan.

Use Cases

  • Reviewing a slow report query
  • Checking queries during code review
  • Learning common SQL performance pitfalls

Frequently Asked Questions