Optimize query performance

After identifying and investigating slow queries, use the optimization tools and guidance in Database Observability to improve performance. These resources help you systematically fix performance problems and get AI-powered suggestions.

What you can do

Improve slow queries: Apply a systematic optimization workflow using explain plans, wait events, schema analysis, and AI-powered suggestions.

Optimization workflow

Identify issues: Use the Queries Overview to find slow or problematic queries.
Investigate root cause: Analyze explain plans, query samples, and wait events.
Review schemas: Check table schemas for missing indexes.
Apply fixes: Follow the slow queries guide to implement optimizations.
Verify improvement: Monitor metrics to confirm performance gains.