Oracle performance when using synonyms

Olav Naerland shared this idea 2 months ago
Idea Logged

We would like the option to use USER_SYNONYMS and USER_OBJECTS instead of ALL_SYNONYMS and ALL_OBJECTS.


Using USER_SYNONYMS reduce the execution time to less than 0.1 second.

Comments (1)

photo
1

Hi Olav,

I hope all is well,

I have gone ahead and raised this as an Enhancement.

Regards,

Mark