Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Need an alternate - SYNONYMS
Your performance issue may have more to do with the use of a DB link.
Which version of Oracle are you using.
Prior to 10g, the optimizer knows nothing about the tables at the
remote database, which could result in performance degredation when you
start joining tables.
HTH. Received on Thu Oct 27 2005 - 11:13:12 CDT