Thursday, 26 February 2015

CREATE INDEX WITH MAXDOP OPTION

CREATE NONCLUSTERED INDEX IX_COLUMN_NAME ON DBO.T_TABLENAME

(COLUMN_NAME) WITH (ONLINE = OFF, MAXDOP = 1)

No comments:

Post a Comment