v_LongUsers

gistfile1.txt

USE StackOverflow
GO
CREATE VIEW v_LongUsers
WITH SCHEMABINDING
AS
  SELECT [Id],
         [AboutMe],
         [Age],
         [CreationDate],
         [DisplayName],
         [DownVotes],
         [EmailHash],
         [LastAccessDate],
         [Location],
         [Reputation],
         [UpVotes],
         [Views],
         [WebsiteUrl],
         [AccountId],
         [CheckSum]
  FROM   [dbo].[Users]
  WHERE  LEN([DisplayName]) > 35;
GO

CREATE UNIQUE CLUSTERED INDEX CIX_VLongUsers
  ON v_LongUsers([Id])
  WITH(ONLINE=OFF, MAXDOP=0);
GO