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!

Can any one explain me excution plan reducing cost or Bytes is better?

653531Jul 9 2009 — edited Jul 9 2009
Hi i have a select statement written in two different ways but same result.

1. First statement bytes is more and cost is less
2.Second statement bytes is reduced 1/3 of first by cost is increase which is the effecient why it so?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 6 2009
Added on Jul 9 2009
8 comments
934 views