Guido,

> Table DOS_CONSTANTS: Index on SHORTCUT and NAME

Delete the SHORTCUT index and create a compound index on SHORTCUT + ID

Also, why are you comparing the names (i.e. TMP.NAME=SA.SANAME), it
seems redundant?


Sean