Answer Posted / 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 |
Post New Answer View All Answers
How do you open a cluster administrator? : sql server DBA
What is fill factor? : sql server DBA
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What is a correlated sub-query? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What is the importance of a recovery model? : sql server DBA
which background process invoke at the time of upgradation tell me???
You create a private database link and upon
connection, fails with: ORA-2085: connects to
what do you understand by flashback feature of oracle?
What are statistics, under what circumstances they go out of date, how do you update them?
how can you connect from 10g user to 11g user??
What is the difference between clustered and non-clustered index? : sql server DBA
what do you understand by fine-grained auditing?
What are the commands you'd issue to show the explain plan for "select * from dual"?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com