Views : They are virtual table and are generally combination of 2 or 3 tables.Being said Virtual they do not occupy space like a normal table.
Indexes on View :
Views are virtual table by default,to use index it’s mandatory to have a physical column.To enable indexes its mandatory to use SCHEMABINDING with views.
create view yourviewname with schemabinding&nbsp; as select &nbsp;v1.column1 ,v1.column2 from v1&nbsp;
Since views are virtual tables,there might be cases where we need to refresh a view when underlying table used in view changes.
Execute SP_RefreshView "yourviewname"
Insert/Update/Delete with Views:
Single select must be used in view with check option enabled.