Re: SQL query
Date: Sun, 28 Nov 2010 18:16:22 +1100
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!
-- tcross (at) rapttech dot com dot auReceived on Sun Nov 28 2010 - 01:16:22 CST