My book is finally available in EMEA:
M-H Education EMEA
http://www.mheducation.co.uk/9780071850094-emea-oracle-sql-developer-data-modeler-for-database-design-mastery
Oracle SQL Developer Data Modeler for Database Design Mastery available in EMEA!
12 Friday Jun 2015
Posted in Data Modeler, Database design, General
HeliFromFinland 
Hi, I just ordered your book for my team. BAsed on this blog and your other articles it looks like it will help us get started with Data Modeler. I have been trying to use it but lots of trial and error. I have 2 questions that might be of interest to other readers: (1) i would like to generate bitmap indexes in DDL for the foreign keys in my relational model. Can’t figure out how to do this. (2) Is there a way to generate a physical model from the relational model? I’m worried that i will have to run the DDL and then import/reverse engineer back into Data Modeler.
Thanks
Thank you, John! I just blogged about creating the physical model. It is very easy and you do not need to worry about it. I will need to think about your first question a little bit but I will come back to that. Thank!
– Heli
Hi again. Is this something you would like to get: CREATE BITMAP INDEX OrderLine_Orders_FK_INDX ON OrderLine ( Orders.OrderNo ASC ) FROM OrderLine , Orders WHERE Orders.OrderNo = OrderLine.Orders_OrderNo NOCOMPRESS NOPARALLEL ; ?
— Heli
Heli, thanks for your responses! Yes I’d like to use data modeler to generate a bitmap index ddl for each foreign key in my star schema fact table that i designed. It’s best practice to have a bitmap index for each fk in a fact table. Thanks in advance.
One more thing. I was thinking of a plain old bitmap index rather than a bitmap join index like in your previous reply. but whatever you can come up with will be good to know.
I just blogged something related to this. I hope it helps.
Heli