"Hou, Zhijie" <houzj.fnst@xxxxxxxxxxxxxx> writes: > Can Initplan placed at the righttree or the lefttree of joinnode? Initplans generally get attached to the topmost node of a given (sub)query, cf create_plan(). You might be able to get what you want by having an unflattenable subquery as one input of a join. I do not think you're going to get any exciting results that way though ... as create_plan() notes, the exact spot where an initplan is attached to the tree isn't terribly relevant. regards, tom lane
