11. The DepartmentHistory table of employees is often queried. The queries are based on the EmployeeID attribute and take a long time to execute. Optimize the execution of these queries.
create Nonclustered index Idx_EmployeeID on HumanResources.EmployeeDepartmentHistory(EmployeeID)
No comments:
Post a Comment