Re: Simple Index question

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: Fri, 17 Dec 1999 11:40:30 -0800
Message-ID: <83e3tb$n2r$1@plo.sierra.com>

In my environment, we have an OK_TO_MAIL flag whose meaning is 'Y' = ok to mail else null = not ok.

It's indexed (the null ones are not in the index of course) so that joins using this field are quite quick.

(on 7.3.2 -- no bitmapped indexes until 7.3.4)

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:40:30 CST