bhaskarreddy006
Member • Nov 30, 2011
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.......... ?