Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE NONCLUSTERED INDEX [NC_Index1] ON [dbo].[anyTable]
- (
- [X] ASC,
- [Y] ASC,
- [Z] ASC
- )
- INCLUDE (A ,
- B,
- C)
- CREATE NONCLUSTERED INDEX [NC_Index2] ON [dbo].[anyTable]
- (
- [X] ASC,
- [Y] ASC,
- [Z] ASC,
- [colm1] ASC,
- [C] ASC
- )
- INCLUDE (A,
- colm2,
- colm3,
- colm4,
- colm5
- )
- CREATE NONCLUSTERED INDEX [NC_Index2] ON [dbo].[anyTable]
- (
- [X] ASC,
- [Y] ASC,
- [Z] ASC,
- [colm1] ASC,
- [C] ASC
- )
- INCLUDE (A,
- B
- colm2,
- colm3,
- colm4,
- colm5
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement