database-indexing - Database Indexing & Query Optimization
Strategies for optimizing database queries through proper indexing and schema design.
Tags
Updated: 2026-02-12Capabilities
Typical Inputs
Typical Outputs
What this skill does
- analyze EXPLAIN query plans
- create B-Tree indexes
- create Hash indexes
- create Full-Text indexes
- create Spatial indexes
- create Composite indexes
- optimize WHERE clause queries
- optimize JOIN condition queries
- optimize sorting/grouping columns
- analyze index cardinality
- test query performance
- monitor index usage
- partition large tables
- analyze slow queries
Inputs
- database queries
- schema structure
- performance metrics
- EXPLAIN plans
- index usage statistics
- cardinality data
Outputs
- optimized SQL queries
- index creation statements
- performance analysis reports
- EXPLAIN plan analysis
- query optimization recommendations
- index management commands
Requirements
- database access
- SQL query execution permissions
- EXPLAIN command support
- index management permissions
- performance monitoring tools