Advertisement
Guest User

Untitled

a guest
Oct 31st, 2014
145
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. CREATE NONCLUSTERED INDEX [NC_Index1] ON [dbo].[anyTable]
  2. (
  3. [X] ASC,
  4. [Y] ASC,
  5. [Z] ASC
  6. )
  7. INCLUDE (A ,
  8. B,
  9. C)
  10.  
  11. CREATE NONCLUSTERED INDEX [NC_Index2] ON [dbo].[anyTable]
  12. (
  13. [X] ASC,
  14. [Y] ASC,
  15. [Z] ASC,
  16. [colm1] ASC,
  17. [C] ASC
  18. )
  19. INCLUDE (A,
  20. colm2,
  21. colm3,
  22. colm4,
  23. colm5
  24. )
  25.  
  26. CREATE NONCLUSTERED INDEX [NC_Index2] ON [dbo].[anyTable]
  27. (
  28. [X] ASC,
  29. [Y] ASC,
  30. [Z] ASC,
  31. [colm1] ASC,
  32. [C] ASC
  33. )
  34. INCLUDE (A,
  35. B
  36. colm2,
  37. colm3,
  38. colm4,
  39. colm5
  40. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement