Re: ** query over db link behaving strange

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Thu, 27 Oct 2005 17:46:51 GMT
Message-ID: <4361122b.1473478468@localhost>

On 27 Oct 2005 09:53:28 -0700, "ajoshi" <ajoshi9777_at_yahoo.com> wrote:

> I have a query selecting from a local table and a view which selects

I've learned that tuning distributed queries in an 'art'.. Try playing with subqueries, e.g. isolate local joins from remote queries.

Another advice someone gave me in this groups earlier, was to create a view on the remote side, and then join with the view. That worked well in some cases.

-a
.......
We use Oracle 8.1.7.4 and 9.2.0.6/7 on Solaris 2.7 and RH4 remove NSPAM to email Received on Thu Oct 27 2005 - 12:46:51 CDT