search on front of compound key
From: robert <gnuoytr_at_rcn.com>
Date: 26 Jun 2003 15:21:20 -0700
Message-ID: <da3c2186.0306261421.3a52c224_at_posting.google.com>
Date: 26 Jun 2003 15:21:20 -0700
Message-ID: <da3c2186.0306261421.3a52c224_at_posting.google.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
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; OtherNonUniqueKey is completely redundant.
thanks,
OtherNonUniqueKey -> col1 + col2
robert
Received on Fri Jun 27 2003 - 00:21:20 CEST