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 are pl/sql cursors?

1049

What is meant by <> in sql?

972

What is pl sql package?

1030

How many columns should be in an index?

959

what does myisamchk do? : Sql dba

1010

What is difference between primary and secondary key?

1023

what are the different type of sql's statements ? : Sql dba

924

What is sharding in sql?

972

Why stored procedure is faster than query?

1054

What is the difference between syntax error and runtime error?

1138

Can we call stored procedure in function?

957

What is foreign key and example?

931

What is pl sql variable?

981

Do we need to rebuild index after truncate?

1031

What is a pragma statement?

1262