Lets assume there is a design where every table is represented by a view, that is simply selecting all of the columns of the table and all the rows.
--vw Select * From sys_table
And I then run a query
Select * From vw Where some_column = some_value
Will the database first execute the query in the view, selecting all the data of that table into memory, like it would if I ran the query independently, and then will it run my actual query that has the where statement?
The reason I was wondering this is I was trying to understand how views work, and was wondering if the database does optimizations like combining queries to make sure it doesn't load the whole data in memory if it doesn't have to.