Re: [GENERAL] Performance of full outer join in 8.3

Tom Lane wrote:
> Greg Stark <stark(at)enterprisedb(dot)com> writes:
...
>> I suppose if we had explain-to-a-table then we could run explain and
>> then run an sql query to verify the specific properties we were
>> looking for.
>
>> A similar thing could be done with xml if we had powerful enough xml
>> predicates but we have a lot more sql skills in-house than xml.
>
> Yeah, I suspect the only really good answers involve the ability to
> apply programmable checks to the EXPLAIN output. A SQL-based solution
> shouldn't need any external moving parts, whereas analyzing XML output
> presumably would.

If only an explain-to-a-table would be one of the available options
and not the only option that would be great. The big O only has this
option and it totally sux if you want to explain a query on a production
environment where you can't just create tables here and there.

Tino