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?

Thanks,
Jon Knight


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

Follow-Ups:

Re: View vs. Synonym (across DBLink)
From: Yechiel Adar

Other related posts:

Browse oracle-l