I am pretty sure that when you run a view
i.e select * from myview where mycolumn='a'
The view is basically
select * from mytable
and shall return the entire data set into memory then perform the filter.
However, I cannot find anything on the whitepapers indicating this and with using Statistics on I cannot see that is happening. Anyway to see this so I can show it to a few developers.