Oracle Database - Execution Plan Predicate

Card Puncher Data Processing

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.

Example

select * from employees
where 
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