• My understanding of Included columns in an index is that they do not affect whether or not an index is selected. Index use is based on the key column(s) in the index from left to right (See the blog posts by Gail Shaw (GilaMonster here on SSC) here[/url] and here[/url]). Included columns allow you to create covering indexes without creating a huge composite key.