CrazyEngineers
  • bhaskarreddy006

    bhaskarreddy006

    MemberNov 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
    .......... ? 
    Replies
Howdy guest!
Dear guest, you must be logged-in to participate on CrazyEngineers. We would love to have you as a member of our community. Consider creating an account or login.
Replies
  • Prasad Ajinkya

    MemberNov 30, 2011

    Bhaskar, I think the direct query will execute faster
    Are you sure? This action cannot be undone.
    Cancel
Home Channels Search Login Register