[Charset iso-8859-1 unsupported, filtering to ASCII...]
> The answer is that you are thinking as indexes in the context of fast lookup
> on fields.
>
> However my requirement comes from a need to ensure that every single field
> in the
> table forms a unique combination. (not my design, I might add)
Ooow, that is a good point. Unique requires a unique index.
>
> Now you know why, can you append it to the TODO list?
Can I get someone else to agree it should be added?
>
> On thinking about it, I wonder if the same field can appear more than
> once in an index. Now that would be weird!
I bet it can.
--
Bruce Momjian | http://www.op.net/~candle
maillist@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026