RE: why so much slower

[Paula_Stankus]

more info.  It seemed just when I went from two to three tables in a join there was a very substantial increase in elapsed time.  I did join with one large table and small codetable alone and performed like a champ.  Hmmmm.  Any ideas?  -----Original Message----- From: Stankus, Paula G Sent: Wednesday, June 05, 2002 3:03 PM To: '[EMAIL PROTECTED]' Subject: RE: why so much slower Set sort_area_size to very large as 20Gb (obscene) amount of space available. Doing 2 large table outer joins returns results in .341 seconds - both partitioned on same criteria added one small codetable equijoin with one of the larger tables.  There is a foreign key to codetable and index that is unique.   Used hash join hint Used nested loop hint   Basically saw two large joins sort merged hash join then nested join to smaller table - much much smaller codetable.   NO matter what it seems query is much much slower - Any ideas?