extracting via view

hi guys,
i have small doubt ....the doubt is regarding the performance issue

consider a table contains 100 columns  
... i have created a view named "VIEW_A" with 100 columns  and another view with 10 columns named its as VIEW_B...

now i am extracting 10 columns of the data from the table using table like ------> select col1,col2,.....col10 form  table 

same using view 
----->select col1,col2,.....col10 form  VIEW_A
for view with less columns   -------------> select from VIEW_B

now in the above queries which one will exectue faster with less memory buffer
.......... ? 


  • Prasad Ajinkya
    Prasad Ajinkya
    Bhaskar, I think the direct query will execute faster

You are reading an archived discussion.

Related Posts

How To Post On CrazyEngineers Forum On CE Forum, you can either participate in any existing discussion or start a new discussion. This short guide explains how to do it....
The new CE-Forum is here to make things simpler for you. Making it simple means having less options and thus less hassle. 👍 Whenever you want to quote another CEan's...
The "Watch Thread" Option is similar to "Subscribe to a Thread" Option. Basically, this option can be used to get updates about the specific threads you are concerned about. To...
CEans, If you have questions about the new platform we've released, please ask them here. We're here to answer all your questions 😀 .
CEans, We told you, December 01 won't be December 01 for CEans. We're quite excited and proud to present you the all new CrazyEngineers Forum. Your journey from being CrazyEngineers...