How would you go about generating an EXPLAIN plan?

Answers were Sorted based on User's Feedback



How would you go about generating an EXPLAIN plan?..

Answer / daid kumar

The EXPLAIN PLAN statement displays execution plans chosen
by the Oracle optimizer for SELECT, UPDATE, INSERT, and
DELETE statements.
Run This Script To create Plan Table
$ORACLE_HOME/rdbms/admin/UTLXPLAN.SQL
Then Write like this
SQL> EXPLAIN PLAN FOR
SELECT name FROM emp;

Now to see O/P u can select * from "plan_table"

Is This Answer Correct ?    9 Yes 1 No

How would you go about generating an EXPLAIN plan?..

Answer / bharath

explain plan for select * from t1 where num_col = '1';
select * from table(dbms_xplan.display);

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More DB Administration Interview Questions

What is the difference between Datapump & export/import?

2 Answers  


Which environment variables are absolutely critical in order to run the OUI?

2 Answers  


WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,


How would you determine what sessions are connected and what resources they are waiting for?

2 Answers  


How would you begin to troubleshoot an ORA-3113 error?

1 Answers  






can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

0 Answers  


Where do you find the default index fill factor and how to change it? : sql server DBA

0 Answers  


how can you connect from 10g user to 11g user??

0 Answers   HP,


How can you control the amount of free space in your index pages? : sql server DBA

0 Answers  


Explain about your sql server dba experience? : sql server DBA

0 Answers  


How can you gather statistics on a table?

3 Answers  


what is asm?

0 Answers   Oracle,


Categories