Al tratar de crear el indice a la siguiente vista me da un error:
Cannot index the view 'BDGES1.dbo.vCUBICAC'. It contains one or more
disallowed constructs.
A que se debera ?
CREATE VIEW dbo.vCUBICAC
WITH SCHEMABINDING
AS
SELECT gD.DOCUMENTO,gD.ccTOTAL, SUM(isnull(gCgD.valor,0)) as pagado,
COUNT_BIG (*) AS CNT
FROM dbo.gD left join dbo.gCgD
on gD.modulo=gCgD.moduloD and gD.tipo=gCgD.tipoD and gD.grupo=gCgD.grupoD
and gD.documento=gCgD.documentoD
GROUP BY gD.DOCUMENTO,gD.ccTOTAL
go
CREATE UNIQUE CLUSTERED INDEX documento ON [dbo].[vCUBICAC]([documento])
ON [PRIMARY]
GO
Me la crea bien pero no el indice. Dice:Cannot index the view
'BDGES1.dbo.vCUBICAC'. It contains one or more disallowed constructs.
Leer las respuestas