Re: Simple Index question

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sat, 18 Dec 1999 19:58:11 +0800
Message-ID: <385B76D3.3F0F@yahoo.com>

boo wrote:
>
> 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.

A summary of the other posts:

1. data evenly spread means that normal index isnt much use
2. uneven distribution could get benefit from normal index
3. bitmap indexes great but:
4. overhead to maintain is more expensive ii) locking concerns are much larger
5. foreign key locking may (or may not) mandate the use of a normal index...

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Sat Dec 18 1999 - 05:58:11 CST