Saved Queries

Save a Query

A view saves a finite query shape over the base table.

highlighted = computed this step

Save a query

A saved query keeps a table shape: selected columns plus a row filter.

saved query shape\text{saved query shape}

Show the saved output

The saved query outputs 2 rows from 2 source rows.

output rows=2\text{output rows}=2

View examples are tiny finite saved-query outputs; SQL dialects, optimizers, security, updatability, materialized-view strategy, performance, and maintenance advice are out of scope.

Save a query: base tableidstatustotal1open502closed203open70 view column mappingsourceoutputididtotaltotal view filteropcolumnvalueeqstatusopen source rows usedbaseRow02 current view outputidtotal150370 view factsfactvaluebaseRowCount3sourceRowCount2rowCount2columnCount2stalenot_materializedhasFilteryeshasAliasesnohasMaterializedCopyno

See the source rows

The source-rows table shows exactly which base rows fed the view.

source rows are visible\text{source rows are visible}

Summary

This is finite saved-query behavior, not a SQL dialect promise.

saved query\text{saved query}