Oracle Database - Execution Plan Predicate
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 where employee_id > 70 and last_name like 'King%'