Nov 30, 2011
hi guys,i have small doubt ....the doubt is regarding the performance issueconsider 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_Afor view with less columns -------------> select * from VIEW_Bnow in the above queries which one will exectue faster with less memory buffer.......... ?