Re: The reason for loving Usenet

From: Mladen Gogala <>
Date: Thu, 26 Apr 2012 01:39:15 +0000 (UTC)
Message-ID: <>

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.

Received on Wed Apr 25 2012 - 20:39:15 CDT

Original text of this message