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 |
--------------------------------------------------------------------------

where are cookies actually stored on the hard disk? : Sql dba

1017

---

Is left join inner or outer by default?

1006

---

What is sqlcommand?

1009

---

What does count (*) mean?

910

---

How do you update f as m and m as f from the below table testtable?

1834

---

Cite the differences between execution of triggers and stored procedures?

1072

---

Explain what is dbms?

1039

---

What is the difference between union and union all command?

1061

---

What is primary key in db?

992

---

How do you take the union of two tables in sql?

970

---

What does sql stand for?

976

---

What is difference between stored function and application function?

1173

---

define join and explain different type of joins? : Sql dba

934

---

Explain correlated query work?

1041

---

How does left join work in sql?

985

---