mgainty@xxxxxxxxxxx (Martin Gainty) writes: > Not the planner but you can hint the query as in this example > select /*+ ordered use_hash(code1)*/ * from table_1; That might have some effect with Oracle; is there some reason why you think this would be expected to have any effect on a PostgreSQL query? -- select 'cbbrowne' || '@' || 'acm.org'; http://www3.sympatico.ca/cbbrowne/x.html Rules of the Evil Overlord #178. "If I have the hero cornered and am about to finish him off and he says "Look out behind you!!" I will not laugh and say "You don't expect me to fall for that old trick, do you?" Instead I will take a step to the side and half turn. That way I can still keep my weapon trained on the hero, I can scan the area behind me, and if anything was heading for me it will now be heading for him." <http://www.eviloverlord.com/> ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
