what is explain plan?, given an example...
- 3 Answers
- 8515 Views
- Polaris, I also Faced
- E-Mail Answers
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
What is schema in sql example?
What pl/sql package consists of?
What is meant by cursor in sql?
Which one is faster ienumerable or iqueryable?
Is sql database free?
What is sqlexception in java?
What are the advantages of indexing?
what is csv? : Sql dba
What is trigger in pl sql?
What is sql exception?
Is it possible to pass parameters to triggers?
What is crud stand for?
Can we use insert statement in function?
What is %type in pl sql?
what is the difference between delete and truncate statement in sql? : Sql dba
