# Patterns

Learn about common Materialize query patterns.




> For the complete documentation index, see [llms.txt](https://preview.materialize.com/materialize/40269/llms.txt).


The following section provides examples of implementing some common query
patterns in Materialize:


## Pages in this section

- [Partitioning and filter pushdown](https://preview.materialize.com/materialize/40269/markdown-docs/transform-data/patterns/partition-by/index.md): Declare how collections are stored.
- [Percentile calculation](https://preview.materialize.com/materialize/40269/markdown-docs/transform-data/patterns/percentiles/index.md): How to use histograms to efficiently calculate percentiles in Materialize.
- [Rules execution engine](https://preview.materialize.com/materialize/40269/markdown-docs/transform-data/patterns/rules-engine/index.md): Encode rules as data and apply them using lateral joins.
- [Temporal filters (time windows)](https://preview.materialize.com/materialize/40269/markdown-docs/transform-data/patterns/temporal-filters/index.md): Perform time-windowed computation over temporal data.
- [Use an ontology table](https://preview.materialize.com/materialize/40269/markdown-docs/transform-data/patterns/ontology/index.md): Create an ontology table that helps agents write correct joins.