what is explain plan?, given an example...
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.
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
how to calculate the difference between two dates? : Sql dba
How do I view a sql trace file?
How does a covering index work?
Is sql developer case sensitive?
What is function and procedure?
how to drop an existing view in mysql? : Sql dba
What are the various levels of constraints?
Cite the differences between execution of triggers and stored procedures?
What are the benefits of stored procedures?
what are the differences between require and include, include_once and require_once? : Sql dba
how can you create an empty table from an existing table? : Sql dba
what is myisam? : Sql dba
Can primary key be changed?
what are the authentication modes in sql server? How can it be changed? : Sql dba
What is composite data type in pl sql?