extracting via view
Question asked by bhaskarreddy006 in #Coffee Room on Nov 30, 2011
Posted in: #Coffee Room
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.......... ?
Bhaskar, I think the direct query will execute faster