I have only used it on Oracle 10g, but dbms_sqltune is a PL/SQL package that implements the SQL Tuning Advisor. I wrote some PHP for my users to find their que

I have only used it on Oracle 10g, but dbms_sqltune is a PL/SQL package that implements the SQL Tuning Advisor. I wrote some PHP for my users to find their queries and run the analyzer, and it will suggest new indexes among other performance-enhancing options. There is also this SQLite index suggestion tool on the front page today... https://news.ycombinator.com/item?id=31991598 https://news.ycombinator.com/item?id=31991598