Oracle Database - Execution Plan Predicate

1 - About

An execution plan can show two type of predicates:

  • An access Predicate. It is a means to avoid processing unneeded data at all.
  • A filter predicate. It filters everything from child row source. The non-matching rows are thrown away.

3 - Example

SELECT * FROM employees
WHERE 
employee_id > 70 AND
last_name LIKE 'King%'

4 - Documentation / Reference

db/oracle/predicate.txt · Last modified: 2017/09/13 16:16 by gerardnico