RE: View vs. Synonym (across DBLink)

  • From: "Daniel Wittry" <daniel.wittry@xxxxxxxxx>
  • To: <Oracle-L@xxxxxxxxxxxxx>
  • Date: Mon, 31 Jan 2005 09:36:10 -0800

You didn't ask about materialized views, but they are one possible
option when optimizing queries across dblinks.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Knight, Jon
Sent: Monday, January 31, 2005 9:13 AM
To: Oracle-L@xxxxxxxxxxxxx
Subject: View vs. Synonym (across DBLink)

  While tuning a mammoth query, I noticed that one of the tables in the
from clause is actually a view.  It's defined as "select * from
table_name@dblink".  Is there any reason to believe I could improve
performance by dropping the view and using a synonym instead?

Jon Knight



Other related posts: