Analyzes slow database queries by examining execution plans, index usage, join strategies, and lock contention, then provides optimized queries with indexing recommendations.