View vs. Synonym (across DBLink)

  • From: "Knight, Jon" <jknight@xxxxxxxxxxxxxx>
  • To: Oracle-L@xxxxxxxxxxxxx
  • Date: Mon, 31 Jan 2005 11:12:39 -0600

  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: