{
  "id": "workflow:database-index-optimization",
  "_kind": "Workflow",
  "_file": "workflows/workflows/workflows-deeper-domains.yaml",
  "_cluster": "workflows",
  "attributes": {
    "displayName": "Database Index Optimization",
    "workflowKind": "operational",
    "triggerType": "scheduled",
    "typicalCadence": "monthly",
    "complexity": "single-team",
    "description": "Optimizes database index configurations to improve query performance and\nreduce storage overhead -- analyzing slow-query logs and execution plans\nto identify missing index opportunities, evaluating existing indexes for\nusage frequency and identifying unused or redundant indexes for removal,\nassessing index-bloat levels and scheduling reindex operations, modeling\ncomposite-index column ordering against query selectivity statistics,\ntesting index changes against production-representative workloads in\nstaging, validating lock-free index creation strategies for\nzero-downtime deployment, and benchmarking query-latency improvements\npost-optimization. Produces index optimization report and migration\nscripts. Excludes schema redesign.\n"
  },
  "outgoingEdges": [
    {
      "from": "workflow:database-index-optimization",
      "to": "role:database-administrator",
      "kind": "involves_role",
      "attributes": {}
    },
    {
      "from": "workflow:database-index-optimization",
      "to": "role:staff-engineer",
      "kind": "involves_role",
      "attributes": {}
    },
    {
      "from": "workflow:database-index-optimization",
      "to": "skill-area:postgres-tuning",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:database-index-optimization",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:database-index-optimization",
      "to": "domain:databases",
      "kind": "applies_to_domain",
      "attributes": {}
    },
    {
      "from": "workflow:database-index-optimization",
      "to": "domain:software-engineering",
      "kind": "applies_to_domain",
      "attributes": {}
    },
    {
      "from": "workflow:database-index-optimization",
      "to": "responsibility:performance-budget-tracking",
      "kind": "triggers_responsibility",
      "attributes": {}
    },
    {
      "from": "workflow:database-index-optimization",
      "to": "responsibility:cost-optimization",
      "kind": "triggers_responsibility",
      "attributes": {}
    },
    {
      "from": "workflow:database-index-optimization",
      "to": "org-unit:database-team",
      "kind": "performed_by_org_unit",
      "attributes": {}
    },
    {
      "from": "workflow:database-index-optimization",
      "to": "org-unit:engineering",
      "kind": "performed_by_org_unit",
      "attributes": {}
    }
  ],
  "incomingEdges": []
}