Re: Utility of indexes
From: Bob Badour <bbadour_at_golden.net>
Date: Tue, 11 Nov 2003 11:33:27 -0500
Message-ID: <eYWdnf52karkkiyiRVn-sw_at_golden.net>
Date: Tue, 11 Nov 2003 11:33:27 -0500
Message-ID: <eYWdnf52karkkiyiRVn-sw_at_golden.net>
"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 - 17:33:27 CET