I know how to create index on tables but dont know how to create index on view. I have views virtual tables want to create index on it via pass through query.
CREATE VIEW DBO.VWABC
WITH SCHEMABINDING
AS
SELECT NAME, PO, SAL, DEPT, TERM FROM db
RDER
GO
CREATE UNIQUE CLUSTERED INDEX UIX_PO
ON DBO.VWABC(PO)
I am getting this message?
Incorrect syntax error near keyword 'Create', (#156)
Am I missing anything
CREATE VIEW DBO.VWABC
WITH SCHEMABINDING
AS
SELECT NAME, PO, SAL, DEPT, TERM FROM db

GO
CREATE UNIQUE CLUSTERED INDEX UIX_PO
ON DBO.VWABC(PO)
I am getting this message?
Incorrect syntax error near keyword 'Create', (#156)
Am I missing anything
Last edited: