Explain the EXPLAIN statement ?

The explain statement provides information about the optimizer's choice of access path of the sql.
  • Interview Candidate
  • 1
  • 3170

Showing Answers 1 - 1 of 1 Answers

Prasanth

  • Jun 28th, 2006
 

The EXPLAIN statement obtains information about access path selection for an explainable statement. A statement is explainable if it is a SELECT or INSERT statement, or the searched form of an UPDATE or DELETE statement.The information obtained is placed in a user-supplied plan table

This statement can be embedded in an application program or issued interactively. It is an executable statement that can be dynamically prepared.                                                               

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions