Mat View Use Cases

For example:

{{< tabs >}} {{< tab "3-tier architecture" >}}

In a 3-tier architecture where queries are served from a cluster different from the compute/transform cluster that maintains the view results:

• Use materialized view(s) in the compute/transform cluster for the query results that will be served.

  {{< include-md file="shared-content/stacked-view-consideration.md" >}}

• Index the materialized view in the serving cluster(s) to serve the results from memory.

{{</ tab >}}

{{< tab "2-tier architecture" >}}

In a 2-tier architecture where queries are served from the same cluster that performs the compute/transform operations:

• Use view(s) in the shared cluster.

• Index the view(s) to incrementally update the view results and serve the results from memory.

{{< include-md file="shared-content/shared-cluster-indexed-view-tip.md" >}}

{{</ tab >}} {{< tab "1-tier architecture" >}}

In a 1-tier architecture where queries are served from the same cluster that performs the compute/transform operations:

• Use view(s) in the shared cluster.

• Index the view(s) to incrementally update the view results and serve the results from memory.

{{< include-md file="shared-content/shared-cluster-indexed-view-tip.md" >}}

{{</ tab >}} {{</ tabs >}}