Re: View vs. Synonym (across DBLink)

  • From: Juan Carlos Reyes Pacheco <juancarlosreyesp@xxxxxxxxx>
  • To: adar76@xxxxxxxxxxxx
  • Date: Mon, 31 Jan 2005 13:58:26 -0400

To optimize you can think in a function table too, if there are too
much joins and calculations.


On Mon, 31 Jan 2005 20:48:22 +0200, Yechiel Adar <adar76@xxxxxxxxxxxx> wrote:
> You may want to check where most of the data is.
> There is a hint to use the remote table as driving table for the query. I
> think it is "driving_table".
> I used it once and it made a huge difference.
> 
> Yechiel Adar
> Mehish Computer Services
> ----- Original Message -----
> From: "Knight, Jon" <jknight@xxxxxxxxxxxxxx>
> To: <Oracle-L@xxxxxxxxxxxxx>
> Sent: Monday, January 31, 2005 7:12 PM
> 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
> 


-- 
Oracle 9i,10g Certified Professional
Experience on Orace 7,8i
Developer 6i Certified Professional

8 years of experience in Administration, developing and design
--
//www.freelists.org/webpage/oracle-l

Other related posts: