Re: The reason for loving Usenet
From: Jeremy <jeremy0505_at_gmail.com>
Date: Thu, 26 Apr 2012 10:41:15 +0100
Message-ID: <MPG.2a0328966b2a77bc989997_at_News.Individual.NET>
In article <pan.2012.04.26.01.39.15_at_gmail.com>, gogala.mladen_at_gmail.com says...
>
> 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.
Date: Thu, 26 Apr 2012 10:41:15 +0100
Message-ID: <MPG.2a0328966b2a77bc989997_at_News.Individual.NET>
In article <pan.2012.04.26.01.39.15_at_gmail.com>, gogala.mladen_at_gmail.com says...
>
> 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.
Actually, the moderator probably made the right call. Keeping everything as professional as possible will cultivate respect amongst all participants. It could otherwise be the "thin end of the wedge" as people become increasingly "free" with their language.
Where the line is drawn between what is acceptable and what is not is obviously subjective.
-- jeremyReceived on Thu Apr 26 2012 - 04:41:15 CDT