II.
LibraryProcess overview
Reference · livelib-process:data-engineering-analytics--query-optimization
query-optimization overview
Query Performance Optimization - Comprehensive query performance analysis and optimization covering profiling, indexing strategies, partitioning, query rewriting, materialized views, and caching for optimal database performance.
Attributes
displayName
query-optimization
description
Query Performance Optimization - Comprehensive query performance analysis and optimization covering profiling,
indexing strategies, partitioning, query rewriting, materialized views, and caching for optimal database performance.
libraryPath
library/specializations/data-engineering-analytics/query-optimization.js
specialization
data-engineering-analytics
references
- - Query Optimization Best Practices: https://use-the-index-luke.com/ - PostgreSQL Performance: https://wiki.postgresql.org/wiki/Performance_Optimization - MySQL Query Optimization: https://dev.mysql.com/doc/refman/8.0/en/optimization.html - SQL Server Performance: https://docs.microsoft.com/en-us/sql/relational-databases/performance/ - Database Indexing Strategies: https://planet.postgresql.org/
example
const result = await orchestrate('specializations/data-engineering-analytics/query-optimization', {
database: 'PostgreSQL',
workloadType: 'OLAP',
querySet: ['SELECT * FROM orders WHERE ...', 'SELECT customer_id, SUM(amount) ...'],
performanceTargets: {
p95Latency: 500,
throughput: 1000,
cacheHitRate: 0.8
},
enableAutoOptimization: true,
optimizationAreas: ['indexing', 'partitioning', 'materialization', 'caching']
});
usesAgents
- query-profiler
- plan-analyzer
- index-architect
- partitioning-specialist
- query-optimizer
- materialization-architect
- caching-architect
- config-tuner
- statistics-manager
- monitoring-engineer
- optimization-planner
- implementation-engineer
- validation-engineer
- technical-writer
Outgoing edges
lib_applies_to_domain1
- domain:data-engineering·DomainData Engineering
lib_belongs_to_specialization1
- specialization:data-engineering-analytics·Specialization
lib_implements_workflow1
- workflow:data-pipeline-deployment·WorkflowData Pipeline Deployment
uses_agent3
- lib-agent:performance-optimization--caching-architect·LibraryAgentcaching-architect
- lib-agent:shared--implementation-engineer·LibraryAgentimplementation-engineer
- lib-agent:meta--technical-writer·LibraryAgenttechnical-writer
Incoming edges
None.