Saved Queries

Refresh the Copy

Refreshing makes the stored copy match the current output in this tiny model.

highlighted = computed this step

Refresh the copy

Refreshing replaces the stored copy with the current saved-query output in this tiny model.

refresh to current output\text{refresh to current output}

Show the refreshed copy

The refreshed view has 1 row, and the stale flag is no.

rows=1\text{rows}=1

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

Refresh the copy: base tableidstatustotal1closed502closed203open80 view column mappingsourceoutputididtotaltotal view filteropcolumnvalueeqstatusopen source rows usedbaseRow2 current view outputidtotal380 materialized copyidtotal380 view factsfactvaluebaseRowCount3sourceRowCount1rowCount1columnCount2stalenohasFilteryeshasAliasesnohasMaterializedCopyyes

Compare again

After refresh, the current output and materialized copy match.

copy equals current\text{copy equals current}

Summary

No refresh schedule, performance, or maintenance strategy is modeled.

finite refresh\text{finite refresh}