Create a view that combines details from Orders, Products, Customers, and Employees. This view abstracts the complexity of multiple table joins. LEFT JOIN Sales.Products AS p ON p.ProductID = ...

Query optimizer doesn't consider the index in the execution plan for any Transact-SQL statements. For more information about filtered indexes, see Create filtered indexes and the SQL Server index ...