Skip to Main Content

SQL & PL/SQL

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!

Will lower cost queries run faster than higher cost ones always?

PLSQL_GUYFeb 26 2017 — edited Mar 1 2017

I get the same result-set using 2 methods.

One SQL uses sub-queries, the cost is 3.

The other SQL uses joins and the cost is 2.

Does this mean that the query which uses sub-queries will run 33.33% slower than the query which uses joins?

I.e. If it takes 3 minutes for the query with sub-queries to execute, does this mean that the query with

joins will take only 2 minutes, given all other conditions are equal?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 29 2017
Added on Feb 26 2017
21 comments
16,412 views