SQL index advisor

This advisor reads text only. Nothing is executed, no statistics are consulted, and nothing leaves the page. Column order follows fixed rules: equality columns first, then at most one range column, then ORDER BY and GROUP BY columns when a statement filters on equalities alone. Size numbers come from the entry formula (column widths plus 14 bytes) times rows times 1.3, with widths guessed from your DDL, so treat them as a ballpark. Run EXPLAIN against the real database before creating anything.