With IDERA DB Optimizer, database SQL queries can be optimized for multiple platforms via a single user interface. The SQL tuning assistant offers automatic solution suggestions and provides the relevant context for SQL code optimization. A color-coded index analysis identifies used, unused, or missing indices, and performance optimizations are recommended. The case generation feature allows for the creation of different scenarios in order to find the best option for a specific SQL statement. This considers SQL rewrites, and hint injections. IDERA DB Optimizer can be tested for free and pricing is available upon request.