Re: SQL query

From: Tim X <timx_at_nospam.dev.null>
Date: Sun, 28 Nov 2010 18:16:22 +1100
Message-ID: <87mxotzznd.fsf_at_puma.rapttech.com.au>

The Boss <nltaal_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!

Tim

-- 
tcross (at) rapttech dot com dot au

Received on Sun Nov 28 2010 - 01:16:22 CST