My question surrounds the missing index DMVs.
If you take any good missing index DMV - Bart Duncan's for example http://blogs.msdn.com/bartd/archive/2007/07/19/are-you-using-sql-s-missing-index-dmvs.aspx
and run it against any DB, one thing that puzzles me is that the PK of the table is frequently in the "include columns" list.
Why is this? The PK is already there, why does it suggest it be "included" as well.
Thanks for the insight.