CREATE TABLE [dbo].[TBL](
	[INN] [varchar](20) NULL,
	[OGRN] [varchar](50) NULL,
	[KPP] [varchar](20) NULL,
	[NAMEP] [varchar](1024) NULL,
	[NAMES] [varchar](1024) NULL,
	[STATUS] [int] NULL,
	[DTSTART] [datetime] NULL,
	[DATA] [datetime] NULL,
	[OKATO] [varchar](20) NULL,
 	[INDEKS] [int] NULL,
	[REGION_NAME] [varchar](255) NULL,
	[RAION_NAME] [varchar](255) NULL,
	[GOROD_NAME] [varchar](255) NULL,
	[NASPUNKT_NAME] [varchar](255) NULL,
	[STREET_NAME] [varchar](255) NULL,
	[DOM] [varchar](50) NULL,
	[KORP] [varchar](50) NULL,
	[KVART] [varchar](50) NULL
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [ix] ON [dbo].[TBL]
(
	[INN] ASC
)
INCLUDE ([STATUS]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

update statistics [dbo].[TBL] with fullscan, maxdop = 8