The Optimize module within Aireforge Studio analyses instances, databases, tables, indexes and even database connections then provides recommendations. The growing list of checks vary from best practices and naming convention violations to missing, duplicate or overlapping indexes and orphaned users.

Note: Aireforge Optimize is designed to assist with the tuning and administration of databases. Therefore, each recommendation should be verified and tested before implementation.