SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Developer , does it show actual execution plan or estimated one?

orausernJan 31 2014 — edited Feb 5 2014

Hi,

We are on Oracle 11.2.0.3 on Linux. I am development DBA and we have team of J2EE developers. Our developers are using SQL Deverloper , the free tool by Oracle. I allways use command line: DBMS_XPLAN.DISPLAY_CURSOR. to verify query plans.

There is an option of execution plan in SQL Developer, but I dont know what it uses behind the scene - does it show estimated plan or the actual plan. I think it is best to allways see the actual plan and not the estimated one (as a best practice).

Can someone help to clarify whether sql developer shows the actual plan or the estimated one?

Thansk,

OrauserN

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 5 2014

Added on Jan 31 2014

#sql-developer

10 comments

4,588 views