what is explain plan?, given an example...
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 |
--------------------------------------------------------------------------
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the select statement in sql?
Explain the significance of the & and && operators in pl sql.
What can sql server reporting services do?
Explain lock escalation? : Transact sql
Explain clause in sql?
Is a table valued function object?
Explain ddl statements in pl/sql?
Can a varchar be a primary key?
what are aggregate and scalar functions? : Sql dba
how can you create an empty table from an existing table? : Sql dba
What is the command used to fetch first 5 characters of the string?
How do I restart sql?
What are schema-level triggers?
Can triggers stop a dml statement from executing on a table?
What are all types of user defined functions?