What are the commands youd issue to show the explain plan
for select
- 2 Answers
- 4242 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 |
How to find out what privileges a user currently has in oracle?
Is oracle an operator?
What types of joins are used in writing subqueries?
What is flashback Query ? And Use ?
What is null value in oracle?
How to call a stored function with parameters?
Point the difference between translate and replace?
How can you merge two tables in oracle?
Will you be able to store pictures in the database?explain.
What is the difference between "as" and "is" in an oracle stored procedure?
How to check your oracle database 10g xe installation?
How to invoke the data pump import utility?
Oracle General 
