DM 3.1 How to Create a Bitmap Index?
How to create a bitmap index with SQL Developer Data Modeler 3.1? In the relational model, the general table properties allows one to list the indices of a table and to specify some of their attributes like such as columns and uniqueness. Additionally, the plain index properties allows further options to set index properties. Unfortunately, I am unable to find the correct place to specify that an index is a bitmap index.
Nonetheless, Data Modeler appears to support bitmap indices because the DDL statements generated for a table with bitmap indices, that has originally been imported from the data dictionary, have correct bitmap index creation statements. However, when I compare any B tree index with a bitmap index within Data Modeler I cannot find an option that specifies the index type as bitmap. Thus, I would greatly appreciate if anyone could tell me how to create bitmap indices with Data Modeler 3.1.
Best regards,
Miikka