Answer Posted / ashok
Explain plan shows the details of the joins cordinality and
time taken.we can easily find the what join is taking much
time in a SQL query. by clicking F5 you can see the explin
plan in PL/SQL developer.
| Is This Answer Correct ? | 11 Yes | 7 No |
Post New Answer View All Answers
What is the purpose of cursors in pl/sql?
What does t sql mean?
Can we rollback delete command?
How do I count records in sql?
How do you use collections in procedure to return the resultset?
What are the topics in pl sql?
Is sql developer case sensitive?
What is the advantage of index in sql?
how many tables will create when we create table, what are they? : Sql dba
What will you get by the cursor attribute sql%found?
What is rtm stands for?
What is pl sql in dbms?
The select into statement is most often used to create backup copies of tables or for archiving records?
what is data integrity? : Sql dba
what is the difference between myisam static and myisam dynamic? : Sql dba