Re: SQL query
From: The Boss <nltaal_at_baasbovenbaas.demon.nl>
Date: Mon, 29 Nov 2010 02:33:23 -0800 (PST)
Message-ID: <f0f91ea6-1283-4abc-9b46-6710a9f82fa1_at_n10g2000yqd.googlegroups.com>
> The Boss <nlt..._at_baasbovenbaas.demon.nl> writes:
> > On Nov 25, 1:27 am, onedbguru <onedbg..._at_yahoo.com> wrote:
> >> So, this SQLquery went it a bar. After looking around, approached 2
> >> tables and asked, "May I join you?...."
>
> > I've analysed the statistics and they tell me that when offered such a
> > query in a bar it is only natural to choose a hash joint path ...
>
> Ah, so your using stats gathered from Amsterdam! Using such stats in
> other domains could result in a very poor plan and some high lock
> contention!
>
Date: Mon, 29 Nov 2010 02:33:23 -0800 (PST)
Message-ID: <f0f91ea6-1283-4abc-9b46-6710a9f82fa1_at_n10g2000yqd.googlegroups.com>
On Nov 28, 8:16 am, Tim X <t..._at_nospam.dev.null> wrote:
> The Boss <nlt..._at_baasbovenbaas.demon.nl> writes:
> > On Nov 25, 1:27 am, onedbguru <onedbg..._at_yahoo.com> wrote:
> >> So, this SQLquery went it a bar. After looking around, approached 2
> >> tables and asked, "May I join you?...."
>
> > I've analysed the statistics and they tell me that when offered such a
> > query in a bar it is only natural to choose a hash joint path ...
>
> Ah, so your using stats gathered from Amsterdam! Using such stats in
> other domains could result in a very poor plan and some high lock
> contention!
>
<grin>
Close enough,
I'm living (and working) at a distance of ~120 km (~75 miles) from
A'dam.
-- JeroenReceived on Mon Nov 29 2010 - 04:33:23 CST