[1666943 views]

[]

Odi's astoundingly incomplete notes

New entries | Code

Format Oracle plan_table

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