I have used SentryOne Plan Explorer to perform index tuning and index analysis with great success on SQL Server and Azure SQL Database.
What are some of the better equivalent tools to consider for other DBEs such as PostgreSQL, MySQL, and Oracle?
Context: We're performing a "Database Engine Comparison" analysis to compare when we might use a non-SQL Server option. This analysis includes not just the cost of hosting/running the DBE but also maintenance, development, and tooling. While there are some other tools that we have questions about (backup automation, version control, etc.), I'm currently tackling the index tuning portion of our analysis.
I don't care what OS it runs on. I do not currently have any price requirements until I have an idea what the options are. The tool I am currently using (SentryOne Plan Explorer) only works with SQL Server, thus I am specifically lacking compatibility with PostgreSQL, MySQL, and Oracle. I need it to assist me in performing index tuning and index analysis.