> Maybe it is time to swallow hard and redesign the querytree
> representation? I think we really need a multi-level-plan
> data structure right out of the starting gate... a format
> closer to the plantree structure that the executor uses would
> probably be less trouble all around.
Well, while you do that keep in mind outer joins. We've been
discussing it, and it is pretty clear that rte's cannot hold the join
info, since the same source table can participate in more than one
join. So we might have to carry the info in a special kind of
qualification node, which allows the planner/optimizer to generate
subselects below and above that node, but does not allow it to try the
full range of different combinations of joins across it (since it
appears to me that outer joins have only limited possibilities for
rearrangement of the query).
But perhaps a redesigned querytree could carry the info more
naturally...
- Thomas
--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California