How to create index on View and how to use in sql query

[adnancanada]

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 dbo.ORDER
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

[ItsMe]

I don't see any syntax errors. Do you have any red squiggles? I would expect a different message if a view name or something already existed.

[adnancanada]

I don't see any syntax errors. Do you have any red squiggles? I would expect a different message if a view name or something already existed.

Thanks , I am using virtual tables dbo.order is already view. I don't see any red squiggles.

[ItsMe]

Hmm, I am not an expert with DDL statements. I tried to reproduce the error by trying to index a column on a view of another view. Instead, I got a more descriptive error.

Perhaps you can get help over in this other forum. I have found it a useful resource.
https://social.msdn.microsoft.com/Fo...databasedesign