# Query Performance

> The degree to which splitting data across normalized relations forces costly joins on read.

Record: `lexicon:query-performance`
Kind: quality-attribute
Layer: [Contracts Core](https://banes-lab.com/records/layer/contracts-core.md)
Canonical: https://banes-lab.com/ontology/lexicon#lexicon-query-performance

Listed in [Lexicon terms](https://banes-lab.com/api/records/lexicon.md), after [Non-Redundant Storage](https://banes-lab.com/records/lexicon/non-redundant-storage.md) and before [Reduced Redundancy](https://banes-lab.com/records/lexicon/reduced-redundancy.md).

## Category

- [Schema / Canonical Data / Semantics](https://banes-lab.com/records/lexicon-category/schema-canonical-data-semantics.md)

## In tension with

- [Normalization](https://banes-lab.com/records/architecture/normalization.md)
- [Normalization / Query Performance](https://banes-lab.com/records/tension/normalization-query-performance.md)

## Linked from

- [Separate, trade, or mitigate](https://banes-lab.com/software-architecture/principles/separate-trade-or-mitigate.md)
- [Schema / Canonical Data / Semantics](https://banes-lab.com/ontology/principles/architecture-category-schema-canonical-data-semantics.md)
- [The resolutions](https://banes-lab.com/ontology/schema/the-resolutions.md)