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.

Explain what is sql?

1096

---

What's the difference between inner join and left join?

984

---

What is equi join in sql?

1056

---

Does pl/sql support create command?

1086

---

what is the difference between inner and outer join? Explain with example. : Sql dba

1011

---

Does access use sql?

1018

---

What is identity column in sql server?

1034

---

Name the different types of indexes in sql and define them.

1119

---

What is before trigger?

987

---

What is a crud api?

938

---

Define concurrency control. : Transact sql

1153

---

How do I view a view in sql?

936

---

what is row? : Sql dba

1205

---

what is the difference difference between procedure and packages

10364

---

What is the trigger in sql?

929

---