I have a macro that does this. I need to test it with the current version of ER/Studio, plus check to see which special cases I've dealt with (like not renaming indexes that already exist, etc.)
I will try to work on that this week and next.
Please publish the macro. I need it for my company's Oracle data models fro forward engineering.
Can you provide us with a macro that in the physical model creates a non-unique index for every fk constraint?
Under Modeling Productivity Macros there's a "Create Index for Each FK Column" macro. I'm not sure if that's what you're looking for but it could get you started.
I did try to use that macro but it has the following results that need changing.