Use index advisor

MySQL   |  PostgreSQL   |  SQL Server

Preview

This feature is subject to the "Pre-GA Offerings Terms" in the General Service Terms section of the Service Specific Terms. Pre-GA features are available "as is" and might have limited support. For more information, see the launch stage descriptions.

Note: Index advisor requires query insights for Cloud SQL Enterprise Plus edition.

This page describes the Cloud SQL for SQL Server index advisor, and how you can view and apply its index recommendations.

Cloud SQL for SQL Server offers an index advisor that tracks the queries your database handles. Periodically, it analyzes these queries to recommend new indexes that can increase the queries' performance.

Enable index advisor recommendations

Index advisor doesn't require Gemini, but does require query insights for Cloud SQL Enterprise Plus edition for enablement.

For more information, see Enable query insights for Cloud SQL Enterprise Plus edition.

Disable index advisor recommendations

You can disable index advisor by disabling query insights for Cloud SQL Enterprise Plus edition in the Google Cloud console.

For more information, see Disable query insights for Cloud SQL Enterprise Plus edition.

View the index advisor's recommendations

Cloud SQL for SQL Server automatically runs the index advisor's analysis periodically.

What's next

• Use query insights