Karen, they are still indexed and can be used as an index.
Albert
On 31/10/2012 2:13 PM, [email protected] wrote:
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
No virus found in this message.
Checked by AVG - www.avg.com <http://www.avg.com>
Version: 2013.0.2742 / Virus Database: 2617/5853 - Release Date: 10/25/12
