This script will iterate over all the tables in your model and all of their relations and create an FK/join index for the relation if one doesnt already exist.

Only makes sense for databases like Oracle that don't auto create FK/Join indexes.  For databases that do, ModelRight auto-creates them as well.

 To run it:

1) bring up the Script Explorer

2) right click on "User Defined" and select "New Script"

3) copy/paste the attachment into the edit control

4) hit the run button (the first icon in the toolbar above the edit control)

Note: you can undo/redo the effects of this script as with any Model changes