Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: View vs. Synonym (across DBLink)

RE: View vs. Synonym (across DBLink)

From: Daniel Wittry <daniel.wittry_at_quest.com>
Date: Mon, 31 Jan 2005 09:36:10 -0800
Message-ID: <B5C5F99D765BB744B54FFDF35F6026210D4B0318@irvmbxw02>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US