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 …