Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Simple Index question
If the data is evenly distributed , this is waste of storage. Most likely as
one of the two values will account for more than 10 percent, the CBO will
not use it at all. You need to look into using bitmap indexes.
Hth,
--
Sybrand Bakker, Oracle DBA
boo <boo_at_yahoo.com> wrote in message news:385A7F75.783EBE84_at_yahoo.com...
> I have a relatively simple index question;
> A developer has asked that an index be placed on a table column that
> stores either a 1 or 0 value.
> There are two other indexes on this particular table.
> I'm not sure if this will actually help anything, but would appreciate
> any discenting viewpoints and opinions.
>
> Thanks in advance.
>
>
>
Received on Fri Dec 17 1999 - 13:25:47 CST