Saved Queries

Filter the View

A view can keep only rows that match one equality filter.

highlighted = computed this step

Filter the view

A filter keeps only matching rows. Here the filter is one equality check.

one equality filter\text{one equality filter}

Show kept rows

The base has 3 rows. The filtered view keeps 2 rows.

kept rows=2\text{kept 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.

Filter the view: base tableidstatustotal1open502closed203open70 view column mappingsourceoutputididstatusstatustotaltotal view filteropcolumnvalueeqstatusopen source rows usedbaseRow02 current view outputidstatustotal1open503open70 view factsfactvaluebaseRowCount3sourceRowCount2rowCount2columnCount3stalenot_materializedhasFilteryeshasAliasesnohasMaterializedCopyno

Read the filter table

The filter table shows the exact column and value used to choose rows.

filter is visible\text{filter is visible}

Summary

Unsupported predicate shapes fail closed instead of being guessed.

scoped predicate\text{scoped predicate}