Hi List,

I have a Query. So when i do explain analyse on it , it shows me many Hash
Joins.
So is it possible to indicate the Query Planner not to consider Hash Join.

--
Regards
Gauri

On Mon, Feb 26, 2007 at 05:19:05PM +0530, Gauri Kanekar wrote:
> I have a Query. So when i do explain analyse on it , it shows me many Hash
> Joins.
> So is it possible to indicate the Query Planner not to consider Hash Join.

set enable_hashjoin = false;

This is very often the wrong solution, though. If hash join is indeed slower
than merge join, the planner should have guessed so, and it would be better
to find out why the planner guessed wrong, and correct it somehow.

/* Steinar */
--
Homepage: http://www.sesse.net/

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings