A simple question was posed today while giving a presentation on query plan analysis to colleagues at the office. What’s the difference between a composite (multi column) index and an INCLUDE covering index? At the time I was stumped.  Fortunately I don’t have any problem admitting I don’t know something… it happens all the time. [...]