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