what is explain plan?

Answer Posted / b.v.srinivas

Explian plan describes the effective way to process sql
statement.
Explain plan is generated by Optimizer.
And explain plan is stored in library cache.

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is query cache in mysql? : Sql dba

581


Is sqlite thread safe?

611


What can sql server reporting services do?

586


How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

586


What does pl sql stand for?

661






Which software is used for pl sql programming?

526


How do you copy a table in sql?

564


How do you optimize a stored procedure in sql?

506


What is scalar function in sql?

536


How do you rank data in sql?

518


what is sql in mysql? : Sql dba

574


Does group by remove duplicates?

556


Does inner join remove duplicates?

524


How does sql*loader handles newline characters in a record? : aql loader

591


What is the maximum rows in csv?

493