Analyzing Database Indexes

What it does

This skill analyzes database indexes to identify potential performance bottlenecks and areas for optimization. It can assess index usage, fragmentation, and redundancy within a given database schema. The tool provides insights into how existing indexes impact query performance and suggests improvements or removals based on analysis.

When to use it

• Slow Query Investigation: Identify if missing or inefficient indexes are contributing to slow query execution times.
• Database Maintenance Planning: Determine which indexes require maintenance (e.g., rebuilding, reorganizing) due to fragmentation.
• Schema Optimization: Evaluate the overall index strategy for a database and identify redundant or unused indexes that can be removed.
• Performance Tuning After Changes: Analyze index performance after significant data changes or application updates.

Key capabilities

• Index usage analysis
• Fragmentation assessment
• Redundancy detection
• Performance impact evaluation
• Optimization suggestions

Example prompts

• "Analyze the indexes on the 'orders' table in my database."
• "Identify any redundant indexes within the 'customers' schema."
• "What is the fragmentation level of the index on the 'product_id' column?"

Tips & gotchas

This skill requires access to the database schema and metadata. Ensure the AI agent has appropriate permissions to query system views or catalog tables for index information.