extracting via view

bhaskarreddy006

bhaskarreddy006

@bhaskarreddy006-LEB19M Oct 25, 2024

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

Welcome, guest

Join CrazyEngineers to reply, ask questions, and participate in conversations.

CrazyEngineers powered by Jatra Community Platform

  • Prasad Ajinkya

    Prasad Ajinkya

    @prasad-aSUfhP Nov 30, 2011

    Bhaskar, I think the direct query will execute faster