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?

Thanks,
Jon Knight


--
http://www.freelists.org/webpage/oracle-l

Other related posts: