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.

Articles Related

Example

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

Documentation / Reference

• Oracle SQL Plan Execution: How it really works - Tanel Põder