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.

how to include character strings in sql statements? : Sql dba

1129

---

Is pl sql still used?

1014

---

How do I count duplicates in sql?

1168

---

What does sign mean sql?

1171

---

Which data type is a composite type?

1029

---

Does truncate remove indexes?

1073

---

Which tcp/ip port does sql server run?

1062

---

How do I add a primary key to a table?

1079

---

What is the difference between cluster and non-cluster index?

1151

---

Can 2 queries be executed simultaneously in a distributed database system?

1186

---

what is a control file ? : Sql dba

1084

---

How do I start pl sql?

986

---

What is the difference between in and between in sql?

1102

---

What are the two parts of design view?

1057

---

What does pl sql stand for?

1151

---