SQL Query Optimizer

Analyze SQL queries to find optimization opportunities and performance issues

50/100 EFFICIENCY SCORE • -60% ESTIMATED I/O

Raw SQL Query

Optimization Plan & Indexes

Avoid SELECT * Wildcard

Specify only required columns to reduce memory consumption and network I/O.

Leading Wildcard in LIKE Clause

Leading wildcard ("%term") prevents B-Tree index lookups and causes full table scans. Use full-text search (e.g. tsvector / trigram index).

Unbounded Result Set (No LIMIT)

Consider adding a LIMIT clause to prevent buffer overrun on large tables.

Recommended B-Tree / GIN Indexes:

CREATE INDEX idx_text_search ON items USING gin(to_tsvector('english', name));

Optimized SQL Statement:

SELECT id, created_at, status
FROM orders
JOIN customers ON orders.customer_id = customers.id
WHERE orders.status = 'PENDING'
  AND customers.name LIKE '%tech%'
ORDER BY orders.created_at DESC;
LIMIT 100;