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: