Interested to Buy Any Domain ? << Click Here >> for more details...
what is explain plan?, given an example...
- 3 Answers
- 9732 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 are inner and outer joins examples of both?
How do I find duplicates in the same column?
Why is partition used in sql?
Explain the savepoint statement.
What is the difference between pl and sql?
What is primary key in db?
Is sql free?
What is the use of nvl function?
How do you rank data in sql?
How do you explain an index number?
Explain the difference in execution of triggers and stored procedures?
What is sql*loader and what is it used for? : aql loader
How many subqueries can be nested in a statement?
Why is normalization important?
What are the constraints available in sql?
