SQLServerCentral

Column in Key v Include


https://www.sqlservercentral.com/Forums/Topic1910918.aspx

By Steve Jones - SSC Editor - Monday, December 4, 2017 2:23 AM

An article that looks at whether there is a reason to include a column as an index key or as an include. Test ordered output as well as if the extra column is used in aggregates.
By tim_harkin - Thursday, April 12, 2018 10:56 PM

Steve - I would like to write this one up.
By Steve Jones - SSC Editor - Friday, April 13, 2018 3:49 AM

Take it, Tim. It would be good to have 3-4 examples of why it's good or not good.
By David Fundakowski - Friday, October 5, 2018 5:32 AM

Did this get written up?
By Steve Jones - SSC Editor - Monday, October 8, 2018 12:23 AM

Not that I've seen. Feel free to experiment and write this one up