dbTalk Databases Forums  

SQL query

comp.databases.oracle.server comp.databases.oracle.server


Discuss SQL query in the comp.databases.oracle.server forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
onedbguru
 
Posts: n/a

Default SQL query - 11-24-2010 , 06:27 PM






So, this SQLquery went it a bar. After looking around, approached 2
tables and asked, "May I join you?...."

Reply With Quote
  #2  
Old   
Noons
 
Posts: n/a

Default Re: SQL query - 11-25-2010 , 04:27 AM






onedbguru wrote,on my timestamp of 25/11/2010 11:27 AM:
Quote:
So, this SQLquery went it a bar. After looking around, approached 2
tables and asked, "May I join you?...."


<groan>

Reply With Quote
  #3  
Old   
mhoys
 
Posts: n/a

Default Re: SQL query - 11-26-2010 , 03:27 AM



On Nov 25, 1:27*am, onedbguru <onedbg... (AT) yahoo (DOT) com> wrote:
Quote:
So, this SQLquery went it a bar. *After looking around, approached 2
tables and asked, "May I join you?...."
"But of course, we have no constraints..." :-)

Reply With Quote
  #4  
Old   
The Boss
 
Posts: n/a

Default Re: SQL query - 11-26-2010 , 10:03 AM



On Nov 25, 1:27*am, onedbguru <onedbg... (AT) yahoo (DOT) com> wrote:
Quote:
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

Reply With Quote
  #5  
Old   
Tim X
 
Posts: n/a

Default Re: SQL query - 11-28-2010 , 01:16 AM



The Boss <nltaal (AT) baasbovenbaas (DOT) demon.nl> writes:

Quote:
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!

Tim

--
tcross (at) rapttech dot com dot au

Reply With Quote
  #6  
Old   
The Boss
 
Posts: n/a

Default Re: SQL query - 11-29-2010 , 04:33 AM



On Nov 28, 8:16*am, Tim X <t... (AT) nospam (DOT) dev.null> wrote:
Quote:
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!

<grin>
Close enough,
I'm living (and working) at a distance of ~120 km (~75 miles) from
A'dam.

--
Jeroen

Reply With Quote
  #7  
Old   
gazzag
 
Posts: n/a

Default Re: SQL query - 11-29-2010 , 05:49 AM



On Nov 26, 4:03*pm, The Boss <nlt... (AT) baasbovenbaas (DOT) demon.nl> wrote:
Quote:
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
Just watch out that you don't end up consuming too many resources
afterwards!

Reply With Quote
  #8  
Old   
joel garry
 
Posts: n/a

Default Re: SQL query - 11-29-2010 , 12:00 PM



On Nov 24, 4:27*pm, onedbguru <onedbg... (AT) yahoo (DOT) com> wrote:
Quote:
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

jg
--
@home.com is bogus.
A cop known as "The Oracle"...
http://www.signonsandiego.com/news/2...ssion-for-cop/

Reply With Quote
  #9  
Old   
The Boss
 
Posts: n/a

Default Re: SQL query - 11-30-2010 , 04:20 PM



On Nov 29, 12:49*pm, gazzag <gar... (AT) jamms (DOT) org> wrote:
Quote:
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!
Now that's where 'GreenIT' comes in:
http://www.greenzer.fr/blog_image_st...3/green-it.jpg
http://www.greenitamsterdam.nl/?p=50
http://www.treehugger.com/green-it-for-dummies.jpg
http://www.hp.com/hpinfo/globalcitiz...ialEdition.pdf

--
Jeroen

Reply With Quote
  #10  
Old   
John Hurley
 
Posts: n/a

Default Re: SQL query - 12-01-2010 , 06:31 AM



Joel:

Quote:
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
So this guy borrowed a lame joke from Tom Kyte who borrowed it from
someone else ... and it is one of the more popular things on cdos
recently?

Guess that shows how far down cdos has sunk ...

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.