Explain Plan determines the execution plan of SQL statement.

what is explain plan?, given an example...

Question Posted / suresh somayajula

Answer Posted / suresh somayajula

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a dynamic query?

1064

What are sql constraints?

1223

What is a table partition?

1200

What is clause?

1221

What is cursor and why it is required?

1251

what is the difference between join and union? : Sql dba

1192

What is pl sql commands?

1089

how would you get the current date in mysql? : Sql dba

1015

What are the datatypes available in pl/sql ?

1144

what is data control language? : Sql dba

1064

What is Materialized View? In What Scenario we Use Materialized View?

9608

Explain table and field in sql?

1110

What if we write return in procedure?

1505

what are local and global variables and their differences? : Sql dba

1130

What are instead of triggers?

1099