Examine the Exhibit 1 to view the structure of and indexes for EMPLOYEES and DEPARTMENTS tables.
Which three statements are true regarding the execution plan?
Exhibit:
A. The view operator collects all rows from a query block before they can be processed but higher operations in the plan.
B. The in-line query in the select list is processed as a view and then joined.
C. The optimizer pushes the equality predicate into the view to satisfy the join condition.
D. The optimizer chooses sort-merge join because sorting is required for the join equality predicate.
E. The optimizer chooses sort-merge join as a join method because an equality predicate is used for joining the tables.