Odi's astoundingly incomplete notes

Here is a simple query that formats Oracle's plan_table in a useful way. No need for complex PLSQL scripts.

select cost, RPAD(' ', 3*depth,' ') || operation operation,
object_name, options from plan_table order by id;

posted on 2007-05-18 11:28 UTC in Code | 0 comments | permalink