Database Engine Tuning Advisor
Grant Fritchey · Apress eBooks · 2014
SQL Server’s performance frequently depends upon having the proper indexes on the database tables. However, as the workload and data change over time, the existing indexes may not be entirely appropriate, and new indexes may be required. The task of deciding upon the correct indexes is complicated by the fact that an index change that benefits one set of queries may be detrimental to another set of queries. These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.