if exists(select * from sys.indexes i where i.[object_id] = OBJECT_ID('AKUZ.T_ROUTE_TEMPLATES_SET', 'U') and i.name = 'IX_ROUTE_TEMPLATES_SET_LpuMain')
	drop index [IX_ROUTE_TEMPLATES_SET_LpuMain] on AKUZ.T_ROUTE_TEMPLATES_SET;
go
	CREATE INDEX [IX_ROUTE_TEMPLATES_SET_LpuMain] ON AKUZ.T_ROUTE_TEMPLATES_SET (LpuMain) WITH (MAXDOP = 0, SORT_IN_TEMPDB = ON, DATA_COMPRESSION = PAGE)
go