Given an SQL query such as

Select Students.name, Students.id

From Students S$,$ Enrollments E

Where S$.$id $=$ E$.$id And E$.$grade $="$A$"$;

the logical plan that executes the SELECT $($E$.$grade $="$A$")$ before the JOIN $($S$.$id $=$ E$.$id$)$

is a good plan because

Group of answer choices

selection generally reduces the number of tuples passed to the next operator.

everyone may have gotten a grade of $"$A$".$

because select is an easier operator to implement for the DB engineer than the complex join.

selection tends to be able to leverage an index to speed up the relation lookup.