![]() | |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
So, this SQLquery went it a bar. After looking around, approached 2 tables and asked, "May I join you?...." |

#3
| |||
| |||
|
|
So, this SQLquery went it a bar. *After looking around, approached 2 tables and asked, "May I join you?...." |
#4
| |||
| |||
|
|
So, this SQLquery went it a bar. *After looking around, approached 2 tables and asked, "May I join you?...." |
#5
| |||
| |||
|
|
On Nov 25, 1:27Â*am, onedbguru <onedbg... (AT) yahoo (DOT) 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 ... |
#6
| |||
| |||
|
|
The Boss <nlt... (AT) baasbovenbaas (DOT) demon.nl> writes: On Nov 25, 1:27*am, onedbguru <onedbg... (AT) yahoo (DOT) 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! |
#7
| |||
| |||
|
|
On Nov 25, 1:27*am, onedbguru <onedbg... (AT) yahoo (DOT) 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 ... -- Jeroen |

#8
| |||
| |||
|
|
So, this SQLquery went it a bar. *After looking around, approached 2 tables and asked, "May I join you?...." |
#9
| |||
| |||
|
|
On Nov 26, 4:03*pm, The Boss <nlt... (AT) baasbovenbaas (DOT) demon.nl> wrote: On Nov 25, 1:27*am, onedbguru <onedbg... (AT) yahoo (DOT) 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 ... Just watch out that you don't end up consuming too many resources afterwards! ![]() |
#10
| |||
| |||
|
|
So, this SQLquery went it a bar. *After looking around, approached 2 tables and asked, "May I join you?...." http://tkyte.blogspot.com/2009/02/sql-joke.html |
![]() |
| Thread Tools | |
| Display Modes | |
| |