What are the commands youd issue to show the explain plan
for select
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 |
What are the differences between char and nchar in oracle?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
How to see the table columns used in an index?
Is oracle an open source?
Explain integrity constraints?
How to turn on or off recycle bin for the session?
Explain parameter file in oracle.
How to select some rows from a table in oracle?
What is the quickest way to fetch the data from a table?
What happens if recursive calls get out of control?
What is the string concatenation operator in oracle?
how do u setup a replication site?