DB Physical Design

Overview

Use this skill to align storage structures with workload shape, growth patterns, and operational constraints.

Scope Boundaries

• Data volume or access distribution creates storage and latency pressure.
• Partitioning or table layout decisions affect manageability.
• Engine-specific behavior requires deliberate configuration.

Core Judgments

• Partitioning strategy (range/hash/list/hybrid) and key choice.
• Hot/cold data tiering and archival layout.
• Table/index storage parameters by engine characteristics.
• Maintenance strategy for bloat, vacuum/reorg, and statistics.