I strongly dislike hints and I use them only when necessary.
The problem with joins over the database link is that in situations
like FROM EMP_at_LINK WHERE EMPNO = 1234, the whole EMP table will
be brought over to the local site, stored in the temporary tablespace,
much to the delight of users who want to do some sorting, and filtered
locally, even in case that EMPNO is the primary key. How is it
possible to filter remotely? Very simple, create a remote view, and
access the view instead of the tables. I find that method to be much more
portable and version independent then hints. Did I mention that I
strongly dislike hints?
--
Mladen Gogala
A & E TV Network
Ext. 1216
> -----Original Message-----
> From: Mercadante, Thomas F
> [mailto:thomas.mercadante_at_labor.state.ny.us]
> Sent: Thursday, September 23, 2004 10:36 AM
> To: 'adar76_at_inter.net.il'; 'adar76_at_inter.net.il'; Oracle-L (E-mail)
> Subject: RE: DB Links
>
>
> Yechial,
>
> The results of this hint are pretty amazing. I have a query
> in production that runs in about 5-10 seconds. When I apply
> this hint, it runs in less than 1 second. This is on 8.1.7.2.
>
> Got to keep on testing it! Thanks again!
>
> Tom Mercadante
> Oracle Certified Professional
>
>
> -----Original Message-----
> From: Yechiel Adar [mailto:adar76_at_inter.net.il]
> Sent: Thursday, September 23, 2004 9:27 AM
> To: 'adar76_at_inter.net.il'; Oracle-L (E-mail)
> Subject: Re: DB Links
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 23 2004 - 09:42:14 CDT
