SMC slow due to missing index on s_user

Hi All,

Took a while but we figured out why SMC was so slow for one of our clients.  As it turns out SMC issues this innocent looking SQL very often

select S_RESP.NAME from SIEBEL.S_PER_RESP , SIEBEL.S_RESP , SIEBEL.S_USER where S_PER_RESP.RESP_ID=S_RESP.ROW_ID AND S_PER_RESP.PER_ID=S_USER.PAR_ROW_ID AND UPPER(S_USER.LOGIN)=UPPER(:1 )

But for our client with 100K’s of user records it ran for 20 seconds.  The problem is the following index is missing.  With the new index the same query runs in just a few milliseconds.