# Materialize Documentation: Build data products > Pages in the Build data products section of the Materialize Documentation. Every link below points at the Markdown source of a documentation page. For the HTML page instead, drop `markdown-docs/` from the URL and drop the trailing `index.md`. - [Overview](https://materialize.com/docs/markdown-docs/transform-data/index.md): Learn how to efficiently transform data using Materialize SQL. - [Dataflow troubleshooting](https://materialize.com/docs/markdown-docs/transform-data/dataflow-troubleshooting/index.md): How to troubleshoot common dataflow-level scenarios where Materialize is not working as expected. - [Dictionary compression](https://materialize.com/docs/markdown-docs/transform-data/dictionary-compression/index.md): Reduce arrangement memory for columns that hold a small set of repeated values. - [FAQ: Indexes](https://materialize.com/docs/markdown-docs/transform-data/faq/index.md): Frequently asked questions about indexes. - [Freshness](https://materialize.com/docs/markdown-docs/transform-data/freshness/index.md): Guides for tuning, monitoring, and troubleshooting data freshness in Materialize. - [How to monitor freshness in Materialize](https://materialize.com/docs/markdown-docs/transform-data/freshness/monitor-freshness/index.md): How to monitor data freshness across your environment and for specific objects in Materialize. - [Fine tune for sub-second freshness](https://materialize.com/docs/markdown-docs/transform-data/freshness/subsecond-freshness/index.md): How to lower the tick rate to get sub-second freshness, and how to verify it by measuring end-to-end latency. - [Freshness troubleshooting](https://materialize.com/docs/markdown-docs/transform-data/freshness/troubleshoot-freshness/index.md): How to diagnose and resolve freshness problems in Materialize. - [Idiomatic Materialize SQL](https://materialize.com/docs/markdown-docs/transform-data/idiomatic-materialize-sql/index.md): Learn about idiomatic Materialize SQL. Materialize offers various idiomatic query patterns, such as for top-k query pattern, first value/last value query paterrns, etc. - [`ANY()` equi-join condition](https://materialize.com/docs/markdown-docs/transform-data/idiomatic-materialize-sql/any/index.md): Use idiomatic Materialize SQL for equi-join whose `ON` expression includes the `ANY()` operator. - [Appendix](https://materialize.com/docs/markdown-docs/transform-data/idiomatic-materialize-sql/appendix/index.md): Idiomatic Materialize appendix, containing example data and cheatsheets - [Example data: items and orders](https://materialize.com/docs/markdown-docs/transform-data/idiomatic-materialize-sql/appendix/example-orders/index.md): Sample data used in various examples. - [Idiomatic Materialize SQL chart](https://materialize.com/docs/markdown-docs/transform-data/idiomatic-materialize-sql/appendix/idiomatic-sql-chart/index.md): Cheatsheet of idiomatic Materialize SQL. - [Window function to idiomatic Materialize](https://materialize.com/docs/markdown-docs/transform-data/idiomatic-materialize-sql/appendix/window-function-to-materialize/index.md): Cheatsheet for window functions to idiomatic Materialize SQL. - [First value in group](https://materialize.com/docs/markdown-docs/transform-data/idiomatic-materialize-sql/first-value/index.md): Use idiomatic Materialize SQL to find the first value in each group. - [Lag over](https://materialize.com/docs/markdown-docs/transform-data/idiomatic-materialize-sql/lag/index.md): Use idiomatic Materialize SQL to access the previous row's value (lag) when ordered by a field that advances in a regular pattern, such as in regular intervals. - [Last value in group](https://materialize.com/docs/markdown-docs/transform-data/idiomatic-materialize-sql/last-value/index.md): Use idiomatic Materialize SQL to find the last value in each group. - [Lead over](https://materialize.com/docs/markdown-docs/transform-data/idiomatic-materialize-sql/lead/index.md): Use idiomatic Materialize SQL to access the next row's value (lead) when ordered by a field that advances in a regular pattern, such as in regular intervals. - [mz_now() expressions](https://materialize.com/docs/markdown-docs/transform-data/idiomatic-materialize-sql/mz_now/index.md): `mz_now()` expressions can only take comparison operators. `mz_now()` expressions cannot be used with disjunctions `OR` in view definitions. - [`NOT IN` subquery](https://materialize.com/docs/markdown-docs/transform-data/idiomatic-materialize-sql/not-in/index.md): Use idiomatic Materialize SQL for `NOT IN (subquery)` predicates to avoid a cross join in the dataflow plan. - [Top-K in group](https://materialize.com/docs/markdown-docs/transform-data/idiomatic-materialize-sql/top-k/index.md): Use idiomatic Materialize SQL to find the top-k/top-n elements in each group. - [Optimization](https://materialize.com/docs/markdown-docs/transform-data/optimization/index.md): Recommendations for query optimization in Materialize. - [Patterns](https://materialize.com/docs/markdown-docs/transform-data/patterns/index.md): Learn about common Materialize query patterns. - [Use an ontology table](https://materialize.com/docs/markdown-docs/transform-data/patterns/ontology/index.md): Create an ontology table that helps agents write correct joins. - [Partitioning and filter pushdown](https://materialize.com/docs/markdown-docs/transform-data/patterns/partition-by/index.md): Declare how collections are stored. - [Percentile calculation](https://materialize.com/docs/markdown-docs/transform-data/patterns/percentiles/index.md): How to use histograms to efficiently calculate percentiles in Materialize. - [Rules execution engine](https://materialize.com/docs/markdown-docs/transform-data/patterns/rules-engine/index.md): Encode rules as data and apply them using lateral joins. - [Temporal filters (time windows)](https://materialize.com/docs/markdown-docs/transform-data/patterns/temporal-filters/index.md): Perform time-windowed computation over temporal data. - [Updating materialized views](https://materialize.com/docs/markdown-docs/transform-data/updating-materialized-views/index.md): Strategies for updating materialized views in production. - [Replace Materialized Views](https://materialize.com/docs/markdown-docs/transform-data/updating-materialized-views/replace-materialized-view/index.md): Learn how to update a materialized view, while preserving dependencies, using CREATE REPLACEMENT and ALTER MATERIALIZED VIEW.