Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Simple Index question

Re: Simple Index question

From: Buck Turgidson <jcman_at_worldnet.att.net>
Date: Sat, 18 Dec 1999 06:57:34 -0800
Message-ID: <83fsse$d5c$1@bgtnsc03.worldnet.att.net>


A bitmap index is only appropriate if the table is relatively static, due to the cost of maintaining it. I think the solution is to educate your developer.

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 Sat Dec 18 1999 - 08:57:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US