[1067843 views]

[]

[toggle ads]

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 CEST in Code | 0 comments | permalink