{
  "id": "lib-process:data-engineering-analytics--query-optimization",
  "_kind": "LibraryProcess",
  "_file": "generated-library/processes.yaml",
  "_cluster": "generated-library",
  "attributes": {
    "displayName": "query-optimization",
    "description": "Query Performance Optimization - Comprehensive query performance analysis and optimization covering profiling,\nindexing 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/\n- PostgreSQL Performance: https://wiki.postgresql.org/wiki/Performance_Optimization\n- MySQL Query Optimization: https://dev.mysql.com/doc/refman/8.0/en/optimization.html\n- SQL Server Performance: https://docs.microsoft.com/en-us/sql/relational-databases/performance/\n- Database Indexing Strategies: https://planet.postgresql.org/"
    ],
    "example": "const result = await orchestrate('specializations/data-engineering-analytics/query-optimization', {\n  database: 'PostgreSQL',\n  workloadType: 'OLAP',\n  querySet: ['SELECT * FROM orders WHERE ...', 'SELECT customer_id, SUM(amount) ...'],\n  performanceTargets: {\n    p95Latency: 500,\n    throughput: 1000,\n    cacheHitRate: 0.8\n  },\n  enableAutoOptimization: true,\n  optimizationAreas: ['indexing', 'partitioning', 'materialization', 'caching']\n});",
    "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"
    ]
  },
  "outgoingEdges": [
    {
      "from": "lib-process:data-engineering-analytics--query-optimization",
      "to": "domain:data-engineering",
      "kind": "lib_applies_to_domain",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-process:data-engineering-analytics--query-optimization",
      "to": "workflow:data-pipeline-deployment",
      "kind": "lib_implements_workflow",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-process:data-engineering-analytics--query-optimization",
      "to": "specialization:data-engineering-analytics",
      "kind": "lib_belongs_to_specialization",
      "attributes": {
        "weight": 0.9
      }
    },
    {
      "from": "lib-process:data-engineering-analytics--query-optimization",
      "to": "lib-agent:performance-optimization--caching-architect",
      "kind": "uses_agent",
      "attributes": {
        "weight": 0.8
      }
    },
    {
      "from": "lib-process:data-engineering-analytics--query-optimization",
      "to": "lib-agent:shared--implementation-engineer",
      "kind": "uses_agent",
      "attributes": {
        "weight": 0.8
      }
    },
    {
      "from": "lib-process:data-engineering-analytics--query-optimization",
      "to": "lib-agent:meta--technical-writer",
      "kind": "uses_agent",
      "attributes": {
        "weight": 0.8
      }
    }
  ],
  "incomingEdges": []
}