table-usage-pattern.html 871 B

123456789
  1. Some general guidelines for usage patterns include:
  2. | Usage Pattern | General Guideline |
  3. |--------------------------------------------------------------------------------|--------------------|
  4. | View results are accessed from a single cluster only;<br>such as in a 1-cluster or a 2-cluster architecture. | View with an [index](/sql/create-index) |
  5. | View used as a building block for stacked views; i.e., views not used to serve results. | View |
  6. | View results are accessed across [clusters](/concepts/clusters);<br>such as in a 3-cluster architecture. | Materialized view (in the transform cluster)<br>Index on the materialized view (in the serving cluster) |
  7. | Use with a [sink](/serve-results/sink/) or a [`SUBSCRIBE`](/sql/subscribe) operation | Materialized view |
  8. | Use with [temporal filters](/transform-data/patterns/temporal-filters/) | Materialized view |