Re: 2 overlapping indexes

cj doodled thusly:

>I have a table with column A, B, C, D and E. The data is unique on A,
>B and C so I create a unique index on that.

And that's it. No more columns needed!

>Now I would also like to
>create a non-unique index on A, B, C and D.

wth4? If you use A,B,C in your predicates, you are already retrieving one single row (unique index). why add D? "to be sure-to be sure"?

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Fri Jan 25 2002 - 07:36:29 CST