han.holl@xxxxxxxxxxxxxxxxxxxx wrote: > On Thursday 11 January 2007 12:34, Richard Huxton wrote: > >>> The query would run much faster with the filter reordered. >>> Is there a way to tell the planner/optimizer that certain functions are >>> more expensive than others, and should be postponed in lazy evaluation ? >>> Or is there a hook in the system that would allow me too look at and >>> maybe reorder expressions before they are executed ? >> Not really. Perhaps look into using a functional/expressional index and >> see if that does the job for you. >> > Oh well, pity. Thanks anyway. > In my case, indexes don't help. Maybe your functions can be marked STABLE or even IMMUTABLE? That should help the planner evaluate them less often. -- Alban Hertroys alban@xxxxxxxxxxxxxxxxx magproductions b.v. T: ++31(0)534346874 F: ++31(0)534346876 M: I: www.magproductions.nl A: Postbus 416 7500 AK Enschede // Integrate Your World //
