On Sun, 20 Jan 2008 09:30:11 +0200 Sim Zacks <sim@xxxxxxxxxxxxxx> wrote: > I've found that multiple simple statements often work faster then > convoluted single statements. I don't want to steal any further time to anyone considering my interest now is just academic since I can't handle any more information I could put into action shortly... but still is there a good reason that several simple statement could run faster than a more complex one? Is the planner able to correlate nearby simple statements? I'd think that a more complex statement gives more clues on what's your target to the planner that can then find a better way to achieve it. And yeah... on more complex statement the human can make things worse, writing unnecessary complex sql. -- Ivan Sergio Borgonovo http://www.webthatworks.it ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
