Is it possible to store the output of EXPLAIN into a table

[Souvik Bhattacherjee]

Hi,

I was just wondering if it is possible to store the output of EXPLAIN into
a table.

create temp table mytab as (select * from (explain select * from table1
where attr = 5) t);


Unfortunately, the query above does not work.


Thanks,

-Souvik