Skip to Main Content
Forums

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!

* vs Column Name in Oracle Query

996283Jul 14 2016 — edited Jul 18 2016

Hi,

I have a SQL query. when i fetch all columns with * then, it returns in less than a seconds but when i put selected columns in query to fetch, it keeps running. I am putting the plan here.

1. In case of putting columns name in query

Capture.PNG

2. In case of putting * in query:

Capture1.PNG

Can anyone halp me out in understanding why it is happening and what should be the solution for it.

Thanks.

Vipin
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 15 2016
Added on Jul 14 2016
28 comments
4,328 views