Interested to Buy Any Domain ? << Click Here >> for more details...
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
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
which background process invoke at the time of upgradation tell me???
what are the differences of where and if in SAS?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
What are the recovery models for a database? : sql server DBA
What purpose does the model database server? : sql server DBA
What is the default fill factor value? : sql server DBA
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
how can you process messages in order asynchronously?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What the different topologies in which replication can be configured? : sql server DBA
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
