Interested to Buy Any Domain ? << Click Here >> for more details...
What are the commands youd issue to show the explain plan
for select
- 2 Answers
- 5150 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 create a new table by selecting rows from another table?
How would you optimize a slow SQL query?
What are the various constraints used in oracle?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
What is an anonymous block?
What is the difference between alert log file and trace file ?
Explain the use of file option in exp command.
How to drop an existing table in oracle?
How to define a data source name (dsn) in odbc manager?
Explain coalesce function?
Write a simple Store procedure and pass parameter to it ?
How to count duplicated values in a column in oracle?
Oracle General 
