extracting via view

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-aSUfhP • Nov 30, 2011

    Bhaskar, I think the direct query will execute faster