Skip to Main Content

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DM 3.1 How to Create a Bitmap Index?

user2602021Mar 21 2012 — edited Mar 22 2012
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
This post has been answered by Philip Stoyanov-Oracle on Mar 22 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 19 2012
Added on Mar 21 2012
2 comments
798 views