1 of 1 people found this helpful
?i'm not sure if you can index on values. have you run the latest set of fk index creation for your version of bsa ? (what version are you on)
have you tried running awr/addm/ash reports when you reproduce the issue and can see why the associated queries are running for so long ?
there could be a lot of reasons for the slow performance, indexing may not be the answer.
Thanks Bill. We will try that after our upgrade if issue persists.