Re: bitmap index

From: Norris <jcheong_at_cooper.com.hk>
Date: 23 Nov 1999 09:47:24 GMT
Message-ID: <81dnrc$1mjc$1@adenine.netfront.net>

What is low cardinality?

Connor McDonald <connor_mcdonald_at_yahoo.com> wrote:
> 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 Tue Nov 23 1999 - 03:47:24 CST