Tim Jacobs wrote:
> The nested loop join performs very quickly, whereas the hash join
> is incredibly slow. If I disable the hash join temporarily then a
> nested loop join is used in the second case and is the query runs
> much more quickly. How can I change my configuration to favor the
> nest
On Wed, Jun 20, 2012 at 1:34 AM, Tim Jacobs wrote:
> The nested loop join performs very quickly, whereas the hash join is
> incredibly slow. If I disable the hash join temporarily then a nested loop
> join is used in the second case and is the query runs much more quickly. How
> can I change my
I am running the following query:
SELECT res1.x, res1.y, res1.z
FROM test t
JOIN residue_atom_coords res1 ON
t.struct_id_1 = res1.struct_id AND
res1.atomno IN (1,2,3,4) AND
(res1.seqpos BETWEEN t.pair_1_helix_1_begin AND
t.pair_1_helix_1_end)
WHERE