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.

What is right join in sql?

0 Answers  

---

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

0 Answers  

---

select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?

2 Answers  

---

What is a dirty read sql?

0 Answers  

---

What is a sql driver?

0 Answers  

---

What is a native sql query?

0 Answers  

---

What will you get by the cursor attribute sql%rowcount?

0 Answers  

---

What is rownum?

0 Answers  

---

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

0 Answers  

---

why we use nocopy?

2 Answers   Polaris,

---

How to add, remove, modify users using sql?

0 Answers  

---

how to use myisamchk to check or repair myisam tables? : Sql dba

0 Answers  

---