Re: bitmap index

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 22 Nov 1999 17:19:31 +0800
Message-ID: <38390AA3.6AAB@yahoo.com>

Norris wrote:
>
> What is the advantage and disadvantage of using bitmap index?

Good:

- fast
- small
- great for low cardinality

Bad:
- concurrency
- update performance

To summarise (very) briefy:

• great for DSS, not so good for OLTP

--

---

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 Mon Nov 22 1999 - 03:19:31 CST