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