Re: View vs. Synonym (across DBLink)

  • From: Scott Dial <smd@xxxxxxxxxxxxxxxxxxxxxxx>
  • To: Oracle-L@xxxxxxxxxxxxx
  • Date: Mon, 31 Jan 2005 12:43:14 -0500

Good thought.  I was also thinking about Distributed Query option.  That might 
help using remote indexes..

-Scott

+++ Daniel Wittry [31/01/05 09:36 -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


-- Scott
--
//www.freelists.org/webpage/oracle-l

Other related posts: