# Add Index

> A technique for adding an index on the fields a slow query filters or sorts by.

Record: `lexicon:add-index`
Kind: technique
Layer: [Performance Core](https://banes-lab.com/records/layer/performance-core.md)
Canonical: https://banes-lab.com/ontology/lexicon#lexicon-add-index

Listed in [Lexicon terms](https://banes-lab.com/api/records/lexicon.md), after [Replace Algorithm](https://banes-lab.com/records/lexicon/replace-algorithm.md) and before [Chunked Processing](https://banes-lab.com/records/lexicon/chunked-processing.md).

## Category

- [Scalability / Performance / Optimization](https://banes-lab.com/records/lexicon-category/scalability-performance-optimization.md)

## Refactors

- [Latency](https://banes-lab.com/records/architecture/latency.md)
- [Algorithmic Efficiency](https://banes-lab.com/records/architecture/algorithmic-efficiency.md)
- [Time Complexity](https://banes-lab.com/records/architecture/time-complexity.md)

## Linked from

- [Scalability / Performance / Optimization](https://banes-lab.com/ontology/principles/architecture-category-scalability-performance-optimization.md)