Oracle Database - Execution Plan Predicate

Card Puncher Data Processing


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.


select * from employees
employee_id > 70 and
last_name like 'King%'

Oracle Database Predicate

Documentation / Reference

Discover More
Oracle Database Sql Execution Parse Tree
SQL Engine - How to read a query plan ?

How to read a query plan (ie a execution tree) ? Each row in the output table corresponds to a single step in the execution plan. The first step is the furthest indented to the right. As it's...

Share this page:
Follow us:
Task Runner