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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
