Vengatc techology logs

SQL Performance debugging – Query Execution plan oracle

Posted in Uncategorized by vengatc on March 26, 2013

explain plan SET STATEMENT_ID=’bad3′ for select * from v_carrier_test where c_id=2;

SELECT cardinality “Rows”,

lpad(' ',level-1)||operation||' '||
      options||' '||object_name "Plan"
 FROM PLAN_TABLE

CONNECT BY prior id = parent_id

AND prior statement_id = statement_id
 START WITH id = 0
       AND statement_id = 'bad3'
 ORDER BY id;