what is explain plan?

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


Please Help Members By Posting Answers For Below Questions

What is form and report?

506


What is constant in pl sql?

506


How do I view a view in sql?

494


Define overloaded procedure?

610


What is not in sql?

484






Advantages and disadvantages of stored procedure?

568


What is a nested table in word?

525


What is a database event trigger?

577


What is nvarchar max in sql?

567


Which language is used in sql?

509


What are different types of keys?

513


what is a field in a database ? : Sql dba

527


what is offset-fetch filter in tsql? : Transact sql

524


What does bitemporal mean?

587


Is sql pronounced sequel or sql?

724