Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: View vs. Synonym (across DBLink)
You didn't ask about materialized views, but they are one possible
option when optimizing queries across dblinks.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Knight, Jon
Sent: Monday, January 31, 2005 9:13 AM
To: Oracle-L_at_freelists.org
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_at_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
Received on Mon Jan 31 2005 - 12:38:49 CST