RE: Hash Join

RE: Hash Join

 

  

. HASH Joins

This setting has to be enabled by the DBA to be available. If your
queries use joins over non-indexed fields, then a HASH join could very
well speed up things by 3-fold. If hash joins are enabled you should
check the SORTHEAP size.




-----Original Message-----
From: Schleicher Jeremy D.
[mailto:db2udbdba-ezmlmshield-x12333748.[Email address protected]
Sent: Tuesday, April 24, 2007 8:13 AM
To: LazyDBA Discussion
Subject: RE: Hash Join

I've been doing that, but I was hoping for something more.

-----Original Message-----
From: Edwards Ed
[mailto:db2udbdba-ezmlmshield-x35626180.[Email address protected]
Sent: Tuesday, April 24, 2007 8:08 AM
To: LazyDBA Discussion
Subject: RE: Hash Join

http://www-1.ibm.com/support/docview.wss?rs=71&uid=swg21179808


-----Original Message-----
From: Schleicher Jeremy D.
[mailto:db2udbdba-ezmlmshield-x6463966.[Email address protected]
Sent: Tuesday, April 24, 2007 8:07 AM
To: LazyDBA Discussion
Subject: RE: Hash Join

It makes my queries run even longer.

-----Original Message-----
From: Edwards Ed
[mailto:db2udbdba-ezmlmshield-x83665968.[Email address protected]
Sent: Tuesday, April 24, 2007 8:06 AM
To: LazyDBA Discussion
Subject: RE: Hash Join

Hey Jeremy,
What does this do for you?

d2set DB2_HASH_JOIN=NO








Please take a few minutes to provide feedback on the quality of service
you received from our staff. The Department of Education values your
feedback as a customer. Commissioner of Education Jeanine Blomberg is
committed to continuously assessing and improving the level and quality
of services provided to you.Simply use the link below. Thank you in
advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Schleicher Jeremy D.
[mailto:db2udbdba-ezmlmshield-x8086598.[Email address protected]
Sent: Tuesday, April 24, 2007 8:01 AM
To: LazyDBA Discussion
Subject: Hash Join

How can I make my hash joins run faster?



Jeremy Schleicher

ERP Database Administrator

Florida State University





---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

DB2 & UDB email list listserv db2-l LazyDBA home page