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

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

View vs. Synonym (across DBLink)

From: Knight, Jon <jknight_at_concordefs.com>
Date: Mon, 31 Jan 2005 11:12:39 -0600
Message-ID: <17ECCBDCF27C544583F2CAD928F953261A548C@memex1.corp.cefs.int> 





  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


Received on Mon Jan 31 2005 - 12:15:19 CST












Original text of this message













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