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

Why query optimization is needed?

923

Can we insert delete data in view?

950

Why truncate is faster than delete?

1109

How you improve the performance of sql*loader? : aql loader

1013

What is pl sql script?

1030

Can we edit a view in sql?

983

what is the bond code in materialized view?

3002

What is not null in sql?

1055

what is the difference between where clause and having clause? : Sql dba

1000

what is a trigger in mysql? Define different types of trigger. : Sql dba

1069

What are the parts of a sql statement?

1090

How do I save a sql query?

1012

How do I run pl sql in sql developer?

1116

How do I count rows in sql query?

988

Define join and name different types of joins?

1008