Filter Sub-Clauses

A filter sub-clause is a sub-clause that references a single table and is not used to determine the access path (it references a single table and does not match the criteria needed for a constraint or access sub-clause).

When the Query Processor has identified the filter sub-clauses, it adds them to an internal list. In a later phase of the optimization algorithm, the Query Processor will assign each filter sub-clause to the filter condition of the table that it references. The filter condition of the table is then used during execution to determine which rows of the table will be included in the result set.

Further Information

Constraint Sub-Clauses

Access Sub-Clauses

Access Path

SQL Execution.


Disclaimer

Geo SCADA Expert 2020