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

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