RE: View vs. Synonym (across DBLink)

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

Thanks all (including those that replied to me directly). Execution time dropped from 18:24 to 01:26, which is acceptable now.

Thanks,
Jon Knight
Senior Database Analyst
2525 Horizon Lake Drive, Suite 120
Memphis, TN 38133
JKnight_at_concordefs.com

901.371.8000 - Phone
800.238.7675 - Phone
901.380.8336 - Fax
www.FirstData.com

First Data's merger with Concord creates "One Company" with enhanced choice, voice and innovation for all customers.

 -----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Juan Carlos Reyes Pacheco

Sent:	Monday, January 31, 2005 11:58 AM
To:	adar76_at_inter.net.il
Cc:	Oracle-L_at_freelists.org
Subject:	Re: View vs. Synonym (across DBLink)

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_at_inter.net.il> 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_at_concordefs.com>
> To: <Oracle-L_at_freelists.org>
> 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_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
>

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

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

Received on Mon Jan 31 2005 - 13:56:22 CST