Re: Bitmap Indexes
From: Vikas Agnihotri <vikas_at_insight.att.com>
Date: 1996/11/08
Message-ID: <slrn586kus.lim.vikas_at_joshua.insight.att.com>#1/1
Date: 1996/11/08
Message-ID: <slrn586kus.lim.vikas_at_joshua.insight.att.com>#1/1
On 7 Nov 1996 22:06:27 GMT, KELLEY SCOTT A <skelley_at_hsc.hac.com> wrote:
>UNOFFICIAL ANSWER
>------------------
>
>CREATE BITMAP INDEX <index_name> on <table_name> (column_name);
>
>
>caveats:
>
>1) only use for low cardinality data (i.e. sex, marital status, color)
>
>2) READ-ONLY until 7.3.3 (I think). Even then very expensive to update
I tried this on Oracle 7.3 on IRIX machine and it gave me 'Invalid CREATE command'. Is there something special I need to do to 'enable' the creation/use of these indexes?
Thanks,
--Vikas
Received on Fri Nov 08 1996 - 00:00:00 CET