Create Indexes With Included Columns
By SQLRx Admin | Performance Tuning , SQL Administration , SQL Server , Tip of the Month
SQL Server Performance Tuning: Create indexes with included columns. I recently did some tuning work on a query that has computed columns in the SELECT. While the index that was being used by the query did contain columns used in the query’s WHERE clause performance was still not as fast as it could be. I […]
Continue reading