RE: Public Synonyms Performance

2001-06-02 Thread Christopher Spence
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

Public Synonyms Performance

2001-06-01 Thread Pablo ksksksk
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

Re: Public Synonyms Performance

2001-06-01 Thread Riyaj_Shamsudeen
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