Menu
  • HOME
  • TAGS

DB Engine Tuning Advisor suggestion improvement

sql-server,query-optimization,database-tuning-advisor

There's 2 different aspects for selecting an index, the fields you need for finding the rows (=actual indexed fields), and the fields that are needed after that (=included fields). If you're always doing top 15 rows, you can totally ignore included fields because 15 keylookups will be fast -- and...