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
-
Prasad AjinkyaBhaskar, I think the direct query will execute faster
You are reading an archived discussion.
Related Posts
How To Post On CrazyEngineers Forum
On CE Forum, you can either participate in any existing discussion or start a new discussion.
This short guide explains how to do it....
The new CE-Forum is here to make things simpler for you.
Making it simple means having less options and thus less hassle. 👍
Whenever you want to quote another CEan's...
The "Watch Thread" Option is similar to "Subscribe to a Thread" Option.
Basically, this option can be used to get updates about the specific threads you are concerned about.
To...
CEans,
If you have questions about the new platform we've released, please ask them here. We're here to answer all your questions 😀 .
CEans,
We told you, December 01 won't be December 01 for CEans. We're quite excited and proud to present you the all new CrazyEngineers Forum. Your journey from being CrazyEngineers...