Say we have Table A, it has an attribute called, MemberID. And say we have a table B, it has an attribute called MemberID. I create indexes on both tables called, “IDX_MEMBER_ID”.
As soon as you create an index of the same name, a warning message appears in Message Explorer. See the screenshot with the message.
Toad will change the index name to “IDX_MEMBER_ID_0” on both tables.
TDM will not change an index name (see the index properties, the name is still the same).
If you display the indexes in Workspace, you will see an index name + extension. This extension is just a legend or caption that marks particular index.
“_0” has been replaced with “(IX1)”, “(IX2)” etc., which is available in current Beta.
In your example, the index will be displayed this way:
See the index extension next to particular attribute. - This information says in which index particular attribute is.
In other words, it says that Member_ID attribute has been assigned to index one - IX1 (and IX1 = “IDX_MEMBER_ID (IX1)” as we can see directly in WS provided that ‘Display Indexes’ option is selected in Format dialog.)
Please see the screenshot of entity.
To sum up: TDM allows you to create indexes of the same name, however you are notified about this directly via a message in Message Explorer and then also during the model verification.
Names of indexes are not changed automatically, just an extension is added. This extension is just a legend that refers to information on attribute versus index - it just says that particular attribute has been assigned to particular index.
I believe it is much clearer now.