What are the commands youd issue to show the explain plan
for select
- 2 Answers
- 4193 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / saraswathi muthuraman
SQL> explain plan for select * from dual;
Explained.
SQL> select
substr (lpad(' ', level-1) || operation || ' (' || options
|| ')',1,30 ) "Operation",
object_name
"Object"
from
plan_table
start with id = 0
connect by prior id=parent_id;
SELECT STATEMENT ()
TABLE ACCESS (FULL)
DUAL
2 rows selected.
| Is This Answer Correct ? | 1 Yes | 0 No |
Explain the use of analyse option in exp command.
Explain an integrity constrains?
What are the uses of linked server and explain it in detail?
How to write an inner join with the where clause in oracle?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
How many types of cluster table in Oracle?
Explain the use of indexes option in imp command.
How to convert character types to numeric types?
In the oracle version 9.3.0.5.0, what does each number shows?
what are the database links ?
What is the difference between substr and instr?
What is system tablespace?
Oracle General 
