{
  "id": "skill-area:index-design",
  "_kind": "SkillArea",
  "_file": "domain/skill-areas/skill-areas-expanded-2.yaml",
  "_cluster": "domain",
  "attributes": {
    "displayName": "Index Design",
    "description": "Designing database indexes — B-tree, hash, GIN, GiST, BRIN,\nbloom filters, covering indexes, partial indexes, and\nindex-only scan optimization for query workload patterns.\n",
    "expertiseLevels": [
      "intermediate",
      "expert"
    ]
  },
  "outgoingEdges": [
    {
      "from": "skill-area:index-design",
      "to": "domain:databases",
      "kind": "applies_to",
      "attributes": {
        "confidence": "primary"
      }
    },
    {
      "from": "skill-area:index-design",
      "to": "skill-area:query-optimizer-internals",
      "kind": "prerequisite_for_learning",
      "attributes": {
        "strength": "helpful"
      }
    }
  ],
  "incomingEdges": [
    {
      "from": "skill-area:query-optimizer-internals",
      "to": "skill-area:index-design",
      "kind": "prerequisite_for_learning",
      "attributes": {
        "strength": "recommended"
      }
    },
    {
      "from": "specialization:database-internals",
      "to": "skill-area:index-design",
      "kind": "contains"
    }
  ]
}