II.
LibraryProcess overview
Reference · livelib-process:performance-optimization--index-strategy-optimization
specializations/performance-optimization/index-strategy-optimization overview
Index Strategy Optimization - Design and implement optimal index strategy for database including query pattern analysis, composite index design, covering index implementation, and index usage monitoring.
Attributes
displayName
specializations/performance-optimization/index-strategy-optimization
description
Index Strategy Optimization - Design and implement optimal index strategy for database including
query pattern analysis, composite index design, covering index implementation, and index usage monitoring.
libraryPath
library/specializations/performance-optimization/index-strategy-optimization.js
specialization
performance-optimization
references
- - Use The Index Luke: https://use-the-index-luke.com/sql/table-of-contents
example
const result = await orchestrate('specializations/performance-optimization/index-strategy-optimization', {
projectName: 'Order Management System',
database: 'mysql',
tables: ['orders', 'order_items', 'customers', 'products']
});
usesAgents
- performance-engineer
Outgoing edges
lib_applies_to_domain1
- domain:software-engineering·DomainSoftware Engineering
lib_belongs_to_specialization1
- specialization:performance-optimization·Specialization
lib_covers_topic1
- topic:observability-driven-development·TopicObservability-Driven Development
lib_implements_workflow1
- workflow:strategic-planning·WorkflowStrategic Planning
lib_involves_role2
- role:backend-engineer·RoleBackend Engineer
- role:sre·Role
lib_requires_skill_area2
- skill-area:performance-monitoring-profiling·SkillAreaPerformance Monitoring and Profiling
- skill-area:profiling-cpu·SkillAreaCPU Profiling
uses_agent1
- lib-agent:software-architecture--performance-engineer·LibraryAgentperformance-engineer
Incoming edges
None.