RE: View vs. Synonym (across DBLink)

  • From: "Parker, Matthew" <matthewp@xxxxxxxxxx>
  • To: <jknight@xxxxxxxxxxxxxx>, <Oracle-L@xxxxxxxxxxxxx>
  • Date: Mon, 31 Jan 2005 09:31:22 -0800

Explain the query and look at the "other" column in the plan_table for =
the query being executed across the db_link. It will show you in most =
cases the query that is being used across the db_link. You can then =
determine if Oracle is misinterpreting the view and not passes the where =
clause components against that object to the other remote database.

-----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: