Oracle Explain

In Oracle what is meant by 'Explain'

Questions by purushotham.dwh

Showing Answers 1 - 3 of 3 Answers

singh.neerajin

  • May 28th, 2008
 

This must be oracle explain plan.

The EXPLAIN PLAN statement displays execution plans chosen by the Oracle optimizer for SELECT, UPDATE, INSERT, and DELETE statements.
 It also helps you to understand the optimizer decisions (for example, why the optimizer chose a nested loops join instead of a hash join), and lets you understand the performance of a query.

  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