Guest User

Untitled

a guest
Jan 18th, 2019
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. SELECT Id,DisplayName
  2. FROM Users
  3. WHERE Reputation > 400000;
  4.  
  5. CREATE INDEX ix_bla on USERS (Reputation)
  6. INCLUDE (Id, DisplayName)
  7.  
  8. CREATE UNIQUE NONCLUSTERED INDEX Users_400k_Club
  9. ON dbo.Users ( DisplayName, Id )
  10. INCLUDE ( Reputation )
  11. WHERE Reputation > 400000
  12. WITH ( DROP_EXISTING = ON );
Add Comment
Please, Sign In to add comment