Sequential Access / Lookup Performance
Kind: tension
Record: tension:lookup-performance-sequential-access
Canonical: Schema
"sequential-access" (execution-core layer) is traded against "Lookup Performance" (execution-core layer) — a principle cannot be scope-separated from a quality, metric, or cost it competes with; resolve by measuring "Lookup Performance" and choosing an explicit operating point.
Listed in Tensions, after Lazy Evaluation / Eager Full Materialization and before Sequential Access / Random Access Requirement.