Re: Bitmap Indexes

In article <55s43t$h79_at_opera.iinet.net.au>, bwimg_at_iinet.net.au (Information Management Group) writes:
>Hi,
>
>I understand that Oracle 7.3 supports Bitmap indexes. But how does
>one create them?
>
>Cheers,
>
>Naru Narayanan
>DBA
>Bank of Western Australia
>

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

        They are mostly designed for DSS systems.

---Scott Kelley, Senior Consultant, Oracle Corp. Received on Thu Nov 07 1996 - 00:00:00 CET