search on front of compound key

[robert]

i can't find a thread which answers the question:
does oracle (8.1.x) benefit from having multiple compound
keys?

NonUniqueKey -col1 + col2 + col3
OtherNonUniqueK ey -col1 + col2

a where clause - where col1 = 'A' and col2 = 'B'

other databases i've used would retrieve (based on the
physical architecture of their index stores) just as fast
on NonUniqueKey; OtherNonUniqueK ey is completely redundant.

thanks,
robert

[Tim Cuthbertson]

Re: search on front of compound key

You are correct, the OtherNonUniqueK ey index is redundant and can safely be
dropped. Actually, it reduces performance on inserts, deletes, and some
updates, as both indexes must be maintained.

Tim

"robert" <gnuoytr@rcn.co mwrote in message
news:da3c2186.0 306261421.3a52c 224@posting.goo gle.com...

i can't find a thread which answers the question:
does oracle (8.1.x) benefit from having multiple compound
keys?
>
NonUniqueKey -col1 + col2 + col3
OtherNonUniqueK ey -col1 + col2
>
a where clause - where col1 = 'A' and col2 = 'B'
>
other databases i've used would retrieve (based on the
physical architecture of their index stores) just as fast
on NonUniqueKey; OtherNonUniqueK ey is completely redundant.
>
thanks,
robert