Views Indexadas

create VIEW dbo.softwaresAtivos
WITH SCHEMABINDING  
AS  
select codsoftware, nome from dbo.software 
where software.status = 'a'
order by nome

--Create an index on the view.  
CREATE UNIQUE CLUSTERED INDEX sa1
    ON softwaresAtivos (nome);