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
- 5303 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 add another datafile to a tablespace?
Is there a combination of "like" and "in" in sql?
SQLERRM is a a. Constraint b. Pre Defined Exception c. Pseduocolumn d. Constant e. None of Above.
Explain overloading. Can functions be overloaded?
What is query image?
How to import one table back from a dump file?
what r routers?
Is primary key = unique key,not null? If yes,please explain IF No,please explain
what is a Nested Loop join?
How to assign values to variables?
Difference between the “verify” and “feedback” command?
How you find out version of installed workflow?
Oracle General 
