Answer Posted / 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 |
--------------------------------------------------------------------------

How does stored procedure reduce network traffic?

968

---

Write a sql query to find the names of employees that begin with ‘a’?

954

---

How do I view tables in mysql?

917

---

What is delimiter in pl sql?

992

---

how to use 'mysql' to run sql statements? : Sql dba

986

---

Why is %isopen always false for an implicit cursor?

1037

---

What are the constraints available in sql?

999

---

Why do we use joins in sql?

911

---

what are the differences between binary and varbinary? : Sql dba

978

---

Define concurrency control. : Transact sql

1105

---

Enlist the characteristics of pl/sql?

1744

---

What is pl sql quora?

1072

---

How do I view a sql database?

985

---

Is primary key is clustered index?

942

---

Can we commit inside a trigger?

945

---