Index covering is a quick and easy solution to many query performance problems. By just adding a column or two to an index you can significantly boost a query's performance.
Creating a non-clustered index that contains all the columns used in a SQL query, a technique called index covering, is a quick and easy solution to many query performance problems. Sometimes just adding a column or two to an index can really boost the query's performance. Check out a couple of all-too-common scenarios where applying index covering can speed up the queries in your Microsoft SQL Server database
No comments:
Post a Comment