ms sql server, create view with index

CREATE VIEW dbo.v_Test
WITH SCHEMABINDING --optional
AS
   SELECT ID, Name FROM dbo.tableName
   WHERE  (Aktif = 1)

GO


CREATE UNIQUE CLUSTERED INDEX idx_v_Test_ID
    ON dbo.v_Test (ID)
GO

Yorumlar