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;
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: