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

What is cursor explain with example?

982

---

What is difference between procedure and trigger?

976

---

Is postgresql a server?

1046

---

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

1032

---

What is string join?

974

---

How to run pl sql program in mysql?

1015

---

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1105

---

What is the difference between view and stored procedure?

959

---

what are the different type of normalization? : Sql dba

1026

---

What is $$ in sql?

987

---

What is execution plan in sql?

1041

---

What is the difference between join and natural join?

927

---

What are sql triggers used for?

994

---

Is hadoop a nosql?

997

---

How do I create a memory optimized filegroup?

959

---