View Feed
Coffee Room
Discuss anything here - everything that you wish to discuss with fellow engineers.
12892 Members
Join this group to post and comment.

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 • Dec 1, 2011
Bhaskar, I think the direct query will execute faster

Share this content on your social channels -