Relational Databases and SQL

The “Access Predicates” and “Filter Predicates” plan columns were introduced long time ago — in Oracle 9.2. What initially seemed to be a pretty small feature turned out to become an important explain plan component, so that predicates are displayed unconditionally by the DBMS_XPLAN facility. In this article we’ll explain this phenomenon and expand along optimizations ideas pioneered in LDL system.

Tables vs. Predicates.pdf (10 pages)