Answer / shivainduja

An explain plan is a representation of the access path that
is taken when a query is executed within Oracle.

SQL> explain plan for select * from emp2;

Explained.

SQL> select * from table (DBMS_XPLAN.display);

PLAN_TABLE_OUTPUT
-------------------------------------
Plan hash value: 2941272003

--------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost
(%CPU)| Time |
--------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 15 | 570 | 3
(0)| 00:00:01 |
| 1 | TABLE ACCESS FULL| EMP2 | 15 | 570 | 3
(0)| 00:00:01 |
--------------------------------------------------------------------------

8 rows selected.

Answer / rajesh venati

this will also work.

An Explain Plan is a tool that you can use to have Oracle
explain to you how it plans on executing your query.

ex:-
SQL> set autotrace on explain
SQL> select * from emp;

Execution Plan
----------------------------------------------------------
Plan hash value: 3956160932

--------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost
(%CPU)| Time |
--------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 14 | 518 | 3
(0)| 00:00:01 |
| 1 | TABLE ACCESS FULL| EMP | 14 | 518 | 3
(0)| 00:00:01 |
--------------------------------------------------------------------------

Answer / suresh somayajula

Explain Plan determines the execution plan of SQL statement.

Is nosql relational?

0 Answers  

---

Mention what is the function that is used to transfer a pl/sql table log to a database table?

0 Answers  

---

How many unique keys can a table have?

0 Answers  

---

What is a table partition?

0 Answers  

---

What is difference between triggers and stored procedures. And advantages of SP over triggers ?

4 Answers   Microsoft, TCS,

---

What is the difference between inner join and outer join?

0 Answers  

---

Is pl sql and postgresql same?

0 Answers  

---

How One can easily select all even, odd, or Nth rows from a table using SQL queries?

4 Answers  

---

Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...

1 Answers  

---

Write a pl/sql script to display the following series of numbers: 99,96,93……9,6,3?

1 Answers  

---

What are the possible values that can be stored in a boolean data field?

0 Answers  

---

When you have to use a default "rollback to" savepoint of plvlog?

0 Answers  

---