what is explain plan?, given an example...
- 3 Answers
- 8783 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
How do I save a stored procedure?
Why do we use joins in sql?
What do you mean by dbms? What are its different types?
How do you drop a trigger?
describe transaction-safe table types in mysql : sql dba
What is write ahead logging in sql server?
How does join work in sql?
Why is pl sql needed?
How does a self join work?
Can you skip header records while loading? : aql loader
Can you sum a count in sql?
How do you write an index?
Differentiate between sga and pga.
How do I view a view in sql?
What is trigger explain it?
