Skip to content

Instantly share code, notes, and snippets.

@radityopw

radityopw/pmp_alter_index1.sql

Last active January 31, 2016 05:14
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save radityopw/f478a887796791431f8f to your computer and use it in GitHub Desktop.
Save radityopw/f478a887796791431f8f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
pmp_alter_index1.sql
CREATE NONCLUSTERED INDEX [index_1] ON [dbo].[all_pt]
(
[nim] ASC,
[pt] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = ON, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment