Synonyms have a sustantal impact on performance. Public synonyms are by far
greater impact on performance than private ones. The use of synonyms can
prove to have a considerable negative impact on cpu time used during parse
phase of queries. It can also prove to negatively impact aging of sql
HI all,
I think someone ask this question before, but I don't
have any mails about this.
What are the performance implications in the use of
PUBLIC synonyms ? (What about private synonyms?)
How does Oracle resolve internally a public synonym
use?
TIA
recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Public Synonyms Performance
HI all,
I think someone ask this question before, but I don't
have any mails about this.
What are the performance implications in the use of
PUBLIC synonyms ? (What about private synonyms?)
How does