1. Home >
  2. Apps >
  3. Groups >

extracting via view

Question asked by bhaskarreddy006 in #Coffee Room on Nov 30, 2011
bhaskarreddy006
bhaskarreddy006 · Nov 30, 2011
Rank D3 - MASTER
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
.......... ? 
Posted in: #Coffee Room
Prasad Ajinkya
Prasad Ajinkya · Dec 1, 2011
Rank B1 - LEADER
Bhaskar, I think the direct query will execute faster

You must log-in or sign-up to reply to this post.

Click to Log-In or Sign-Up