RE: View vs. Synonym (across DBLink)

  • From: "Powell, Mark D" <mark.powell@xxxxxxx>
  • To: Oracle-L@xxxxxxxxxxxxx
  • Date: Mon, 31 Jan 2005 12:31:58 -0500

Unlikely, but to find out for sure.  Run an explain plan and see how Oracle
is solving the query.  Create a synonym and substitute the synonym into the
query then rerun the plan.  Compare.  Make sure to make no other changes
during the test.
HTH -- Mark D Powell --

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Knight, Jon
Sent: Monday, January 31, 2005 12:13 PM
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: