Re: The reason for loving Usenet
Date: Thu, 26 Apr 2012 01:39:15 +0000 (UTC)
Message-ID: <pan.2012.04.26.01.39.15_at_gmail.com>
On Wed, 25 Apr 2012 17:35:22 -0700, joel garry wrote:
> I think you may have goofed. If the distinct was disallowing the remote
> driving site, working around it by removing the distinct (which
> re-allows the remote ops, speeding things up), loading the GTT and
> running the distinct off that may not be so horrible. Otherwise I would
> have posted a comment there to the mod.
Joel, distinct in the join disallows shipping the entire query to the
remote database. The right solution would be to only ship what is needed
from the remote database, which probably means creating a view on the
remote location. Anyway, suggesting GTT when the actual error is caused
by running out of temporary tablespace doesn't strike me as a good idea
any way you turn it.
Besides, my comment was far from being rude or inappropriate. I just
expressed my opinion, moderator's intervention was totally uncalled for
and completely out of place.
-- http://mgogala.byethost5.comReceived on Wed Apr 25 2012 - 20:39:15 CDT