Re: Oracle Bitmap Index

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 18 Jan 2000 18:46:06 +0800
Message-ID: <3884446E.3E11@yahoo.com>

sum_sri_at_yahoo.com wrote:
>
> Is there any upper limit on the number of unique values a column can
> have to create a bitmap index on it. Thanks
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Not really - but obviously the greater the number, the more likely a b-tree index will start to be a better option.

I've seen bitmap indexes with 1000's of distinct values still outperform their b-tree counterparts but there are other issues like update speed and locking.

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 Tue Jan 18 2000 - 04:46:06 CST