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 |
How to find the duplicate rows count from employees table in oracle?
What is the dynamic sql in oracle?
What is a public synonym?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Explain the truncate in oracle?
How to define a variable of a specific record type?
What is the difference between a primary key & a unique key?
How does Oracle guarantee data integrity of data changes?
In which language oracle has been developed?
Why does oracle 9i treat an empty string as null?
when loggined as SYSTEM,how to display all the users of database using sql query?
What is the max number of columns in an oracle table?