Database Index Advisor

Input table schema and queries, suggest indexes. Best practices guide.

Table Schema (CREATE TABLE or column list)

Queries (one per line)

Indexing Best Practices

Index columns used in WHERE, JOIN, ORDER BY, and GROUP BY clauses
Use composite indexes for queries filtering on multiple columns
Place high-selectivity columns first in composite indexes
Avoid over-indexing: each index slows down INSERT/UPDATE/DELETE
Use covering indexes to avoid table lookups
Consider partial indexes for filtered queries (PostgreSQL)
Monitor slow query log to find missing indexes
Do not index columns with low cardinality (e.g., boolean) alone
Regularly analyze index usage and remove unused ones

More Developer Tools tools at toool.cc