Closed terrajobst closed 2 years ago
For example, in this snippet
SELECT ( SELECT COUNT(*) FROM EmployeeTerritories et WHERE et.EmployeeID = e.EmployeeID ) AS TerritoryCount FROM Employees e
the table scan for Employees no longer included e.EmployeeID.
Employees
e.EmployeeID
For example, in this snippet
the table scan for
Employees
no longer includede.EmployeeID
.