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
- 5247 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 do you rate yourself in oracle and sql server ?
What is oracle database client?
Name the various constraints used in oracle?
sql command 2 know current database
How to convert numbers to characters in oracle?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
what is the difference between first normal form & second normal form?
How to use subqueries with the in operator using oracle?
Explain index?
what is pragma?
Explain the use of inctype option in exp command.
What are the database administrators utilities available?
Oracle General 
