Re: SQL query

From: Tim X <>
Date: Sun, 28 Nov 2010 18:16:22 +1100
Message-ID: <>

The Boss <> writes:

> On Nov 25, 1:27 am, onedbguru <> 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 au
Received on Sun Nov 28 2010 - 01:16:22 CST

Original text of this message