Re: Need an alternate - SYNONYMS

From: G Quesnel <dbaguy_ott_at_yahoo.com>
Date: 27 Oct 2005 09:13:12 -0700
Message-ID: <1130429592.763070.205010@g43g2000cwa.googlegroups.com>

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