RE: View vs. Synonym (across DBLink)

From: "Daniel Wittry" <daniel.wittry@xxxxxxxxx>
To: <Oracle-L@xxxxxxxxxxxxx>
Date: Mon, 31 Jan 2005 09:36:10 -0800

You didn't ask about materialized views, but they are one possible
option when optimizing queries across dblinks.




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

Thanks,
Jon Knight


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


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

Follow-Ups:

Re: View vs. Synonym (across DBLink)
From: Scott Dial

RE: View vs. Synonym (across DBLink)

Other related posts: