Re: bitmap or fbi?

Bricklen wrote:

> I was playing with a function-based index (on 9r2), trying to get it to
> mimic the performance of one of my bitmap indices.
>
> fbi:
> create index t_fbi_fidx on t_fbi(
> case when <some criteria> then pkid else null end);
>
> then I tried this:
> create BITMAP index t_fbi_bidx on t_fbi(
> case when <some criteria> then pkid else null end);
>
> ...and to my surprise it worked. Does this make it a bitmap, or an fbi?
> Did I miss something in the manuals?
>
>
> Bricklen

Take a look at the wire diagram at:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_510a.htm#SQLRF01209

You will notice that (UNIQUE) and (BITMAP) are options.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)