Skip to content

Instantly share code, notes, and snippets.

@sheldonhull

sheldonhull/or_index_to_add

Created December 11, 2014 16:15
Show Gist options
  • Save sheldonhull/ef2d134cdd3b47dcdf84 to your computer and use it in GitHub Desktop.
Save sheldonhull/ef2d134cdd3b47dcdf84 to your computer and use it in GitHub Desktop.
Download ZIP
OR test research and response
Raw
or_index_to_add
create unique nonclustered index ix_nc_CoveringIndex on or_test (id, col1, col2) with drop_existing;
Raw
rerun_test1
GO
exec test1 @Id = 400000
go
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment