Aireforge Advisor

The Advisor 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.

Performing an Analysis

Viewing the Results

Index Optimisation

Custom Index Naming Policies

Results Explained