Database ยท SQL Server
How would you handle a practical scenario involving Indexing in SQL Server?
Given a slow query filtering by customer and date, explain how you would inspect the execution plan and decide whether a composite covering index is appropriate.