The Advisor module within Aireforge Studio analyzes 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.

Performing an Analysis

Viewing the Results

Custom Index Naming Policies

Results Explained