Run explain plan on full resultset in SQL Developer

User_1871

A novice question about SQL Developer 18:

When I run the explain plan (either by clicking the button in the toolbar or with dbms_xplan), it seems like the explain plan is only run on a subset of the resultset. The cost is very low.

Whereas, in the SQL query, if I were to force the query to return the full resultset (by using ORDER BY, or something like that) then the cost would much higher. (Sure, sorting is expensive, but I think most of the cost comes from returning the full resultset.)

Is there a way to run the explain plan on the full resultset by default? Or have I misunderstood something?

Thanks.

thatJeffSmith-Oracle

Explain Plans don't include ANY results.

You want the AutoTrace - and then make sure in preferences you have 'Fetch all rows' enabled. Note...that'll get expensive obviously for large query results.

Using 'ORDER BY' changes the query, of course the plan and cost is going to change.

thatJeffSmith-Oracle

Explain Plans don't include ANY results.

You want the AutoTrace - and then make sure in preferences you have 'Fetch all rows' enabled. Note...that'll get expensive obviously for large query results.

Using 'ORDER BY' changes the query, of course the plan and cost is going to change.