Re: bitmap or fbi?

From: Bricklen <Xbricklen_at_yahoo.comX>
Date: Sun, 11 Jan 2004 07:08:14 GMT
Message-ID: <yD6Mb.55739$X%5.30545@pd7tw2no>

Daniel Morgan wrote:
> 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.
>

Thanks for the link. So how would you classify the bitmap index with the index_expression in the table_index clause? Simply as a bitmap index?

Thanks! Received on Sun Jan 11 2004 - 01:08:14 CST