I learn that the indexed view holds the data from base tables while standard view does not holds data.Is it means that the indexed view need memory and standard view don't?
Indexed view needs to be bind with schema object.I am also confused about the point that '*' is not allow in the schema-bind object.For instance:
create view viewname as select * from tablename
The statement above can not work. why?