The clustered index columns are in all of the non clustered indexes.

(Kenneth Fisher) Did you know that whatever columns you pick as your clustered index will be included in any non clustered indexes on the same table? But don’t take my word for it. Let’s take a look!

Read More - Register for Free Membership