Saved Queries

Base Table First

A view starts from a visible base table.

highlighted = computed this step

Base table first

A view starts with a real table. Show the base rows before saving any query shape.

base table first\text{base table first}

Show the base table

The base table has 3 rows, and the view output has 3 columns here.

base rows=3\text{base rows}=3

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

Base table first: base tableidstatustotal1open502closed203open70 view column mappingsourceoutputididstatusstatustotaltotal view filteropcolumnvaluenonenonenone source rows usedbaseRow012 current view outputidstatustotal1open502closed203open70 view factsfactvaluebaseRowCount3sourceRowCount3rowCount3columnCount3stalenot_materializedhasFilternohasAliasesnohasMaterializedCopyno

No filter yet

Every base row is used because this first view shape has no filter.

all rows pass\text{all rows pass}

Summary

The view output is recomputed from the base table, not hand-copied into the lesson.

recomputed output\text{recomputed output}