| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: Utility of indexes
"Juan Pardillos" <sicotom_at_eresmas.com> wrote in message
news:6278687.0311110830.215f56ac_at_posting.google.com...
> Hi,
>
> I have an attribute in a table that I know the number of different
> values it can take is small. However, there are lots of tuples in the
> table. Does it make sense to define an index on that attribute?
>
> Thanks in advance
It probably won't help to have an index on just that attribute, but it might prove valuable as part of a compound index. Received on Tue Nov 11 2003 - 10:33:27 CST
![]() |
![]() |