title: Why Access and Filter Predicates are the same here?
body: <p><a href="https://i.stack.imgur.com/MUZdq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MUZdq.png" alt="enter image description here" /></a></p>
  <p>When I get the autotrace output of the query above using the Oracle SQL Developer, I see that the join condition is used for access and filter predicates. My question is, does it read all the department_ids from the DEPT_ID_PK and then use these IDs to access and filter the employees table? If so, why the employees table has full table scan? Why does it read the employees table again by using the department_ids of the departments table? Could anyone please read this execution plan step by step simply, and explain the reason why the access and filter predicates are used here?</p>
  <p>Best Regards</p>