> For the complete documentation index, see [llms.txt](https://docs.deltastream.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.deltastream.io/reference/sql-syntax/query/materialized-view.md).

# Materialized View

{% content-ref url="/pages/JdjGt7azvjj6C3pFHR5L" %}
[CREATE MATERIALIZED VIEW AS](/reference/sql-syntax/query/materialized-view/create-materialized-view-as.md)
{% endcontent-ref %}

{% content-ref url="/pages/RKpbH9Y8aqizgoVEro5K" %}
[SELECT (FROM MATERIALIZED VIEW)](/reference/sql-syntax/query/materialized-view/select-from-materialized-view.md)
{% endcontent-ref %}