9.3.2

Can anyone confirm for me that btree.extract DOES works for a bitmap index.

As far as I know, BTREE.EXTRACT does not work for bitmap indexes. The current implementation only allows you to use either a SELECT or the undocumented function RTI_BITMAP_SEARCH. The latter is called as follows:

RTI_BITMAP_SEARCH( tableName, columnName, searchType, searchVals )

where:

 tableName -> Name of the table to search. Required.

 columnName -> Name of the column to search. Required.

 searchType -> Type of search to perform. This can be "AND" or "OR"

 searchVals -> @vm delimited list of terms to search for

it returns a @fm delimited list of keys that match the search query.

Hope it helps,

Stefano

I investigated Bitmap and have concerns…

I removed the Btree on a F-type field of a table and made it a Bitmap. v 9.2.1

Concerns:

1. On a SELECT statement I found it is case-sensitive. Is this documented as such? The data is all upper-case.

What happens if the data is mixed case but should be indexed as all upper or all lower case?

2. A "LIST table column" worked fine, but

3. A "LIST table BY column column" showed No rows processed!!

4. A "LIST table WITH column 'A' 'B' BY column column" does work.

Biggest concern I have is that the BY column without a WITH does not work!

Dave Harmacek

Harmacek Database Systems

View this thread on the Works forum...