When I'm modeling a database I like to create an index for every FK I have, this speed up joins a lot, in Oracle databases it prevents Table Locks.
There could be a new kind of TAssociationProp, something like that TAssociationProp.Indexed, that way you known, you have to create an index.