What's difference between standard view and indexed view in SQL Server
An indexed view is physically stored ("materialised") on disk = requires memory
A standard view is simply an expandable macro: there is no persistence of the data and the base tables are always used


Other notes:


Both will return the correct data from the base tables
SQL Server will consider whether to use the indexed view or just expand it like a macro (subject to edition and NOEXPAND hint)


SELECT * is bad practice anyway, but * means you can't qualify all columns as required for indexed views