In the following queries the
Student table has Clustered Index on
StudentID column, and the
Enrollment Table also has a Clustered Index on
EnrollmentID as well as Non-Clustered index on (
Why the second plan uses look up while both
ShiftID are included in non-clustered index? Why the second query does not have the plan like the first query?