Tom,
> for rec in explain analyze ... loop
> insert into table values(rec."QUERY PLAN");
> end loop;
I need to go further than that and parse the results as well. And preserve
relationships and nesting levels.
Hmmmm ... what's the indenting formula for nesting levels?
--
Josh Berkus
Aglio Database Solutions
San Francisco