> > Table DOS_CONSTANTS: Index on SHORTCUT and NAME
>
> Delete the SHORTCUT index and create a compound index on SHORTCUT + ID
>

This doesn't change anything

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

No, it's ok, because with this comparison I get the SAID


Guido