Question
Key columns versus INCLUDE columns: what differs, and when should each be used?
Answer
Key columns define index order, seek capability, and uniqueness; use them for predicates, joins, and ORDER BY support. INCLUDE columns exist only at the leaf level; use them to cover returned columns without widening the key.