Okay, I've learned a few new things from Larry and they will help me get rid of a bunch of unnecessary indexes at this client. I'm trusting that what he says is right because I didn't see much about multi-column indexes in the "explaining indexes" pdf file.
One more question. There's a few tables with multi-column UNIQUE indexes (rather than a concatenated computed column). I'm assuming that these are used only for enforcing uniqueness, and not used for actual indexing right? Because the tables also have separate single-column indexes on the columns and I'm wondering if they are redundent. Having fun!! I love doing this kind of work! Karen
