Гость
Войти | Профиль | Очистить
Целевая тема:
Создать новую тему:
Автор:
Действия ...
Форумы / Microsoft SQL Server [игнор отключен] [закрыт для гостей] / Блокировки после изменения размера поля / 19 сообщений из 19, страница 1 из 1
26.10.2018, 10:01
    #39723305
Алексей
Алексей
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Блокировки после изменения размера поля
Добрый день

Прошу помощи, поскольку не знаю в какую сторону копать.

Досталась в наследство старая база, в одной из таблиц попросили увеличить размер поля с varchar(2000) до varchar(8000)

После этого через несколько месяцев база начала виснуть. sp_who показывает что виновником является запрос, который обращается к данной таблице. sp_lock показывает что процесс который залочил остальных накладывает порядка 150 -200 блокировок на страницы......

В какую сторону копать?
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
26.10.2018, 10:02
    #39723306
Алексей
Алексей
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Блокировки после изменения размера поля
Да, версия сервера

Microsoft SQL Server 2008 R2 (SP3) - 10.50.6220.0 (X64)
Mar 19 2015 12:32:14
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: )
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
26.10.2018, 10:14
    #39723310
alexeyvg
alexeyvg
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Блокировки после изменения размера поля
АлексейДосталась в наследство старая база, в одной из таблиц попросили увеличить размер поля с varchar(2000) до varchar(8000)

После этого через несколько месяцев база начала виснуть. sp_who показывает что виновником является запрос, который обращается к данной таблице. sp_lock показывает что процесс который залочил остальных накладывает порядка 150 -200 блокировок на страницы......Вообще принципиально при увеличении размера поля ничего не меняется.

Так что скорее всего, блокировки не связаны с этим изменением.

Единственно, после изменении поля, и при интенсивных апдэйтах значений, могла появиться фрагментация таблицы, так что можно попробовать её отребилдить.
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
26.10.2018, 10:21
    #39723314
Алексей
Алексей
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Блокировки после изменения размера поля
alexeyvg,

Вы имеете ввиду пересоздать?
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
26.10.2018, 10:26
    #39723320
alexeyvg
alexeyvg
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Блокировки после изменения размера поля
Алексейalexeyvg,

Вы имеете ввиду пересоздать?Например, можно пересоздать кластерный индекс, если он есть.
Если нет - создать и удалить.
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
26.10.2018, 10:39
    #39723329
Алексей
Алексей
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Блокировки после изменения размера поля
alexeyvg,

Спасибо попробую
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
26.10.2018, 11:13
    #39723342
StarikNavy
StarikNavy
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Блокировки после изменения размера поля
Алексей,

"я позавчера съел мороженное, а сегодня машина не заводится".
давайте план запроса, структуру таблицы и индексов
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
26.10.2018, 11:30
    #39723351
Алексей
Алексей
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Блокировки после изменения размера поля
StarikNavy,

Полностью согласен. Реальную таблицу показать не могу (руководство не разрешило), подготовлю фейковую для примера
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
26.10.2018, 15:01
    #39723565
Алексей
Алексей
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Блокировки после изменения размера поля
StarikNavy,

Структура таблиц и индексов

 
Код: sql
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
207.
208.
209.
210.
211.
212.
213.
214.
215.
216.
217.
218.
219.
220.
221.
222.
223.
224.
225.
226.
227.
228.
229.
230.
231.
232.
233.
234.
235.
236.
237.
238.
239.
240.
241.
242.
243.
244.
245.
246.
247.
248.
249.
250.
251.
252.
253.
254.
255.
256.
257.
258.
259.
260.
261.
262.
263.
264.
265.
266.
267.
268.
269.
270.
271.
272.
273.
274.
275.
276.
277.
278.
279.
280.
281.
282.
283.
284.
285.
286.
287.
288.
289.
290.
291.
292.
293.
294.
295.
296.
297.
298.
299.
300.
301.
302.
303.
304.
305.
306.
307.
308.
309.
310.
311.
312.
313.
314.
315.
316.
317.
318.
319.
320.
321.
322.
323.
324.
325.
326.
327.
328.
329.
330.
331.
332.
333.
334.
335.
336.
337.
338.
339.
340.
341.
342.
343.
344.
345.
346.
347.
348.
349.
350.
351.
352.
353.
354.
355.
356.
357.
358.
359.
360.
361.
362.
363.
364.
365.
366.
367.
368.
369.
370.
371.
372.
373.
374.
375.
376.
377.
378.
379.
380.
381.
382.
383.
384.
385.
386.
387.
388.
389.
390.
391.
392.
393.
394.
395.
396.
397.
398.
399.
400.
401.
402.
403.
404.
405.
406.
407.
408.
409.
410.
411.
412.
413.
414.
415.
416.
417.
418.
419.
420.
421.
422.
423.
424.
425.
426.
427.
428.
429.
430.
431.
432.
433.
434.
435.
436.
437.
438.
439.
440.
441.
442.
443.
444.
445.
446.
447.
448.
449.
450.
451.
452.
453.
454.
455.
456.
CREATE TABLE [dbo].[Item](
	[F0] [int] IDENTITY(1,1) NOT NULL,
	[F1] [varchar](64) NULL,
	[F2] [int] NOT NULL,
	[F3] [int] NOT NULL,
	[F4] [int] NOT NULL,
	[F5] [smallint] NOT NULL,
	[F6] [int] NOT NULL,
	[F7] [smalldatetime] NULL,
	[F8] [int] NOT NULL,
	[F9] [int] NOT NULL,
	[F10] [smalldatetime] NULL,
	[F11] [int] NOT NULL,
	[F12] [varchar](50) NULL ,
	[F13] [int] NULL ,
	[F14] [char](1) NOT NULL,
	[F15] [char](1) NOT NULL,
	[F16] [varchar](200) NULL,
	[F17] [smalldatetime] NULL,
	[F18] [varbinary](85) NULL,
	[F19] [int] NOT NULL,
	[F20] [char](3) NOT NULL ,
	[F21] [varchar](1) NULL,
	[F22] [varchar](1) NULL,
	[F23] [varchar](500) NULL,
	[F24] [varchar](500) NULL,
	[F25] [varchar](1) NULL,
	[F26] [varchar](1) NULL,
	[F27] [varchar](1) NULL,
	[F28] [varchar](1) NULL,
	[F29] [char](1) NOT NULL,
	[F30] [varbinary](85) NOT NULL,
	[F31] [smalldatetime] NOT NULL,
	[F32] [varbinary](85) NOT NULL,
	[F33] [smalldatetime] NOT NULL,
	[F34] [char](1) NULL,
	[F35] [char](1) NULL,
	[F36] [varchar](50) NULL ,
	[F37] [varchar](30) NULL,
	[F38] [varchar](30) NULL,
	[F39] [varchar](30) NULL,
	[F40] [smalldatetime] NULL,
	[F41] [smallint] NULL,
	[F42] [int] NULL,
	[F43] [int] NULL,
	[F44] [int] NULL,
	[F45] [int] NULL,
	[F46] [int] NULL,
	[F47] [varchar](50) NULL,
	[F48] [bit] NULL,
	[F49] [smalldatetime] NULL,
	[F50] [varchar](8000) NULL,
	[F51] [int] NULL,
	[F52] [varchar](30) NULL,
	[F53] [varchar](30) NULL,
	[F54] [varchar](2000) NULL,
	[F55] [varchar](300) NULL,
	[F56] [uniqueidentifier],
	[F57] [int] NOT NULL,
	[F58] [int] NOT NULL,
	[F59] [int] NOT NULL,
	[F60] [int] NOT NULL,
	[F61] [int] NOT NULL,
	[F62] [tinyint] NULL,
	[F63] [varchar](100) NULL,
	[F64] [varchar](1500) NULL,
	[F65] [varchar](3000) NULL,
	[F66] [varchar](1500) NULL,
	[F67] [varchar](3000) NULL,
	[F68] [smalldatetime] NULL,
	[F69] [tinyint] NULL,
	[F70] [varchar](100) NULL,
	[F71] [smalldatetime] NULL,
	[F72] [smalldatetime] NULL,
	[F73] [smallint] NULL,
	[F75] [int] NULL,
	[F76] [varchar](2050) NULL,
	[F78] [tinyint] NOT NULL,
	[F79] [int] NULL,
	[F80] [int] NULL,
	[F81] [int] NULL,
	[F82] [datetime] NULL,
 CONSTRAINT [PK_339902] PRIMARY KEY CLUSTERED 
(
	[F0] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]


CREATE NONCLUSTERED INDEX [IX_1] ON [dbo].[Item]
(
	[F15] ASC
)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

CREATE NONCLUSTERED INDEX [IX_2] ON [dbo].[Item]
(
	[F15] ASC,
	[F29] ASC
)
INCLUDE ( 	[F0],
	[F33],
	[F69]) 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

CREATE NONCLUSTERED INDEX [IX_3] ON [dbo].[Item]
(
	[F31] ASC
)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


CREATE NONCLUSTERED INDEX [IX_4] ON [dbo].[Item]
(
	[F33] ASC
)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

CREATE NONCLUSTERED INDEX [IX_5] ON [dbo].[Item]
(
	[F9] ASC
)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


CREATE NONCLUSTERED INDEX [IX_6] ON [dbo].[Item]
(
	[F75] ASC
)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



CREATE NONCLUSTERED INDEX [IX_7] ON [dbo].[Item]
(
	[F19] ASC
)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


CREATE NONCLUSTERED INDEX [IX_8] ON [dbo].[Item]
(
	[F44] ASC
)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


CREATE NONCLUSTERED INDEX [IX_9] ON [dbo].[Item]
(
	[F57] ASC
)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

CREATE NONCLUSTERED INDEX [IX_10] ON [dbo].[Item]
(
	[F58] ASC
)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


CREATE NONCLUSTERED INDEX [IX_11] ON [dbo].[Item]
(
	[F59] ASC
)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


CREATE NONCLUSTERED INDEX [IX_12] ON [dbo].[Item]
(
	[F60] ASC
)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


CREATE NONCLUSTERED INDEX [IX_13] ON [dbo].[Item]
(
	[F61] ASC
)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


CREATE NONCLUSTERED INDEX [IX_14] ON [dbo].[Item]
(
	[F14] ASC
)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


CREATE NONCLUSTERED INDEX [IX_15] ON [dbo].[Item]
(
	[F4] ASC
)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



CREATE NONCLUSTERED INDEX [IX_16] ON [dbo].[Item]
(
	[F79] ASC
)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


CREATE NONCLUSTERED INDEX [IX_17] ON [dbo].[Item]
(
	[F29] ASC
)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


CREATE NONCLUSTERED INDEX [IX_18] ON [dbo].[Item]
(
	[F45] ASC
)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


CREATE NONCLUSTERED INDEX [IX_19] ON [dbo].[Item]
(
	[F7] ASC
)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


CREATE NONCLUSTERED INDEX [IX_20] ON [dbo].[Item]
(
	[F17] ASC
)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


CREATE UNIQUE NONCLUSTERED INDEX [IX_21] ON [dbo].[Item]
(
	[F56] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO


CREATE NONCLUSTERED INDEX [IX_22] ON [dbo].[Item]
(
	[F1] ASC
)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


CREATE NONCLUSTERED INDEX [IX_23] ON [dbo].[Item]
(
	[F3] ASC
)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



CREATE NONCLUSTERED INDEX [IX_24] ON [dbo].[Item]
(
	[F5] ASC
)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


CREATE NONCLUSTERED INDEX [IX_25] ON [dbo].[Item]
(
	[F42] ASC
)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


CREATE NONCLUSTERED INDEX [IX_26] ON [dbo].[Item]
(
	[F11] ASC
)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


CREATE NONCLUSTERED INDEX [IX_27] ON [dbo].[Item]
(
	[F37] ASC
)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

CREATE NONCLUSTERED INDEX [IX_28] ON [dbo].[Item]
(
	[F38] ASC
)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


CREATE NONCLUSTERED INDEX [IX_29] ON [dbo].[Item]
(
	[F2] ASC
)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


CREATE NONCLUSTERED INDEX [IX_30] ON [dbo].[Item]
(
	[F6] ASC
)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

CREATE TABLE [dbo].[Dict1](
	[G1] [int] IDENTITY(1,1) NOT NULL,
	[G2] [varchar](900) NOT NULL,
	[G3] [varchar](900) NULL,
	[G4] [char](1) NOT NULL,
	[G5] [char](1) NOT NULL,
	[G6] [varbinary](85) NOT NULL,
	[G7] [smalldatetime] NOT NULL,
	[G8] [varbinary](85) NOT NULL,
	[G9] [smalldatetime] NOT NULL,
	[G10] [varchar](100) NULL,
	[G11] [varchar](100) NULL,
	[G12] [varchar](50) NULL,
	[G13] [varchar](50) NULL,
	[G14] [bit] NULL,
	[G15] [int] NULL,
	[G16] [char](1) NOT NULL,
	[G17] [int] NOT NULL,
	[G18] [uniqueidentifier] ROWGUIDCOL  NULL,
	[G19] [bit] NULL,
	[G20] [tinyint] NULL,
	[G21] [varchar](900) NULL,
	[G22] [varchar](900) NULL,
	[G23] [varchar](900) NULL,
	[G24] [bit] NULL,
 CONSTRAINT [PK_0554E0BE] PRIMARY KEY CLUSTERED 
(
	[G1] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
 CONSTRAINT [C_1] UNIQUE NONCLUSTERED 
(
	[G2] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_31] ON [dbo].[Dict1]
(
	[G4] ASC
)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

CREATE  NONCLUSTERED INDEX [IX_32] ON [dbo].[Dict1]
(
	[G17] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_33] ON [dbo].[Dict1]
(
	[G14] ASC
)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

CREATE NONCLUSTERED INDEX [IX_34] ON [dbo].[Dict1]
(
	[G16] ASC
)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

CREATE TABLE [dbo].[Dict2](
	[H1] [int] IDENTITY(1,1) NOT NULL,
	[H2] [nvarchar](254) NOT NULL,
	[H3] [nvarchar](254) NOT NULL,
	[H4] [nvarchar](254) NOT NULL,
	[H5] [nvarchar](254) NOT NULL,
	[H6] [int] NOT NULL,
	[H7] [int] NOT NULL,
	[H8] [char](1) NOT NULL,
	[H9] [varbinary](85) NOT NULL,
	[H10] [smalldatetime] NOT NULL,
	[H11] [varbinary](85) NOT NULL,
	[H12] [smalldatetime] NOT NULL,
	[H13] [varchar](254) NULL,
	[H14] [varchar](254) NULL,
	[H15] [varchar](50) NULL,
	[H16] [varchar](50) NULL,
	[H17] [varchar](50) NULL,
	[H18] [smalldatetime] NULL,
	[H19] [tinyint] NULL,
	[H20] [int] NULL,
	[H21] [uniqueidentifier] ROWGUIDCOL  NULL,
	[H22] [tinyint] NULL,
	[H23] [varchar](254) NULL,
 CONSTRAINT [PK__87GFB8D] PRIMARY KEY CLUSTERED 
(
	[H1] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

CREATE NONCLUSTERED INDEX [IX_35] ON [dbo].[Dict2]
(
	[H8] ASC
)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

CREATE NONCLUSTERED INDEX [IX_36] ON [dbo].[Dict2]
(
	[H10] ASC
)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

CREATE NONCLUSTERED INDEX [IX_37] ON [dbo].[Dict2]
(
	[H15] ASC
)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

CREATE NONCLUSTERED INDEX [IX_38] ON [dbo].[Dict2]
(
	[H11] ASC
)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

CREATE NONCLUSTERED INDEX [IX_39] ON [dbo].[Dict2]
(
	[H12] ASC
)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

CREATE NONCLUSTERED INDEX [IX_40] ON [dbo].[Dict2]
(
	[H19] ASC
)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

CREATE NONCLUSTERED INDEX [IX_41] ON [dbo].[Dict2]
(
	[H7] ASC
)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

CREATE NONCLUSTERED INDEX [IX_42] ON [dbo].[Dict2]
(
	[H2] ASC
)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

CREATE NONCLUSTERED INDEX [IX_43] ON [dbo].[Dict2]
(
	[H6] ASC
)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


CREATE  NONCLUSTERED INDEX [IX_44] ON [dbo].[Dict2]
(
	[H20] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_45] ON [dbo].[Dict2]
(
	[H1] ASC
)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

...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
26.10.2018, 15:16
    #39723569
aleks222
aleks222
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Блокировки после изменения размера поля
Да, круто. Подразделение ФСБ или внешняя разведка?

АлексейВ какую сторону копать?
В сторону "показать проблемный запрос".
Только... настоящий.
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
26.10.2018, 15:16
    #39723570
Алексей
Алексей
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Блокировки после изменения размера поля
StarikNavy,

Виновник блокировок согласно sp_who2

Код: sql
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
Select 
dbo.Item.[F0],
dbo.Item.[F1],
dbo.Item.[F7],
dbo.Item.[F17],
dbo.Item.[F33],
dbo.Item.[F38],
dbo.Item.[F50],
dbo.Item.[F64],
dbo.Item.[F82],
dbo.Dict1.[G2],
dbo.Dict2.[H2]

from dbo.Item 
Inner  JOIN dbo.Dict1 ON dbo.Item.[F9] = dbo.Dict1.[G1]
Inner  JOIN dbo.Dict2 ON dbo.Item.[F11] = dbo.Dict2.[H1]
Where NOT(dbo.Item.[F1] Like '%/%/%') AND 
dbo.Item.[F50] IS not NULL
 AND
 (dbo.Item.[F15]='Д') AND NOT(dbo.Item.[F29]='A')



План выполнения запроса
 
Код: xml
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
207.
208.
209.
210.
211.
212.
213.
214.
215.
216.
217.
218.
219.
220.
221.
222.
223.
224.
225.
226.
227.
228.
229.
230.
231.
232.
233.
234.
235.
236.
237.
238.
239.
240.
241.
242.
243.
244.
245.
246.
247.
248.
249.
250.
251.
252.
253.
254.
255.
256.
257.
258.
259.
260.
261.
262.
263.
264.
265.
266.
267.
268.
269.
270.
271.
272.
273.
274.
275.
276.
277.
278.
279.
280.
281.
282.
283.
284.
285.
286.
287.
288.
289.
290.
291.
292.
293.
294.
295.
296.
297.
298.
299.
300.
301.
302.
303.
304.
305.
306.
307.
308.
309.
310.
311.
312.
313.
314.
315.
316.
317.
318.
319.
320.
321.
322.
323.
324.
325.
326.
327.
328.
329.
330.
331.
332.
333.
334.
335.
336.
337.
338.
339.
340.
341.
342.
343.
344.
345.
346.
347.
348.
349.
350.
351.
352.
353.
354.
355.
356.
357.
358.
359.
360.
361.
362.
363.
364.
365.
366.
367.
368.
369.
370.
371.
372.
373.
374.
375.
376.
377.
378.
379.
380.
381.
382.
383.
384.
385.
386.
387.
388.
389.
390.
391.
392.
393.
394.
395.
396.
397.
398.
399.
400.
401.
402.
403.
404.
405.
406.
407.
408.
409.
410.
411.
412.
413.
414.
415.
416.
417.
418.
419.
420.
421.
422.
423.
424.
425.
426.
427.
428.
429.
430.
431.
432.
433.
434.
435.
436.
437.
438.
439.
440.
441.
442.
443.
444.
445.
446.
447.
448.
449.
450.
451.
452.
453.
454.
455.
456.
457.
458.
459.
460.
461.
462.
463.
464.
465.
466.
467.
468.
469.
470.
471.
472.
473.
474.
475.
476.
477.
478.
479.
480.
481.
482.
483.
484.
485.
486.
487.
488.
489.
490.
491.
492.
493.
494.
495.
496.
497.
498.
499.
500.
501.
502.
503.
504.
505.
506.
507.
508.
509.
510.
511.
512.
513.
514.
515.
516.
517.
518.
519.
520.
521.
522.
523.
524.
525.
526.
527.
528.
529.
530.
531.
532.
533.
534.
535.
536.
537.
538.
539.
540.
541.
542.
543.
544.
545.
546.
547.
548.
549.
550.
551.
552.
553.
554.
555.
556.
557.
558.
559.
560.
561.
562.
563.
564.
565.
566.
567.
568.
569.
570.
571.
572.
573.
574.
575.
576.
577.
578.
579.
580.
581.
582.
583.
584.
585.
586.
587.
588.
589.
590.
591.
592.
593.
594.
595.
596.
597.
598.
599.
600.
601.
602.
603.
604.
605.
606.
607.
608.
609.
610.
611.
612.
613.
614.
615.
616.
617.
618.
619.
620.
621.
622.
623.
624.
625.
626.
627.
628.
629.
630.
631.
632.
633.
634.
635.
636.
637.
638.
639.
640.
641.
642.
643.
644.
645.
646.
647.
648.
649.
650.
651.
652.
653.
654.
655.
656.
657.
658.
659.
660.
661.
662.
663.
664.
665.
666.
667.
668.
669.
670.
671.
672.
673.
674.
675.
676.
<?xml version="1.0" encoding="utf-16"?>
<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.1" Build="10.50.6220.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
  <BatchSequence>
    <Batch>
      <Statements>
        <StmtSimple StatementCompId="1" StatementEstRows="635.468" StatementId="1" StatementOptmLevel="FULL" StatementSubTreeCost="12.8437" StatementText="Select &#xD;&#xA;dbo.Item.[F0],&#xD;&#xA;dbo.Item.[F1],&#xD;&#xA;dbo.Item.[F7],&#xD;&#xA;dbo.Item.[F17],&#xD;&#xA;dbo.Item.[F33],&#xD;&#xA;dbo.Item.[F38],&#xD;&#xA;dbo.Item.[F50],&#xD;&#xA;dbo.Item.[F64],&#xD;&#xA;dbo.Item.[F82],&#xD;&#xA;dbo.Dict1.[G2],&#xD;&#xA;dbo.Dict2.[H2]&#xD;&#xA;&#xD;&#xA;from dbo.Item &#xD;&#xA;Inner HASH JOIN dbo.Dict1 ON dbo.Item.[F9] = dbo.Dict1.[G1]&#xD;&#xA;Inner HASH JOIN dbo.Dict2 ON dbo.Item.[F11] = dbo.Dict2.[H1]&#xD;&#xA;Where NOT(dbo.Item.[F1] Like '%/%/%') AND &#xD;&#xA;dbo.Item.[F50] IS not NULL&#xD;&#xA; AND&#xD;&#xA; (dbo.Item.[F15]='Д') AND NOT(dbo.Item.[F29]='A')" StatementType="SELECT" QueryHash="0xEB65DAA4B90E18A2" QueryPlanHash="0xC458E8463AE8F27B">
          <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
          <QueryPlan DegreeOfParallelism="24" MemoryGrant="57600" CachedPlanSize="104" CompileTime="11" CompileCPU="11" CompileMemory="680">
            <RelOp AvgRowSize="1537" EstimateCPU="0.0344309" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="635.468" LogicalOp="Gather Streams" NodeId="0" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="12.8437">
              <OutputList>
                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F0" />
                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F1" />
                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F7" />
                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F17" />
                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F33" />
                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F38" />
                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F50" />
                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F64" />
                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F82" />
                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict1]" Column="G2" />
                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict2]" Column="H2" />
              </OutputList>
              <RunTimeInformation>
                <RunTimeCountersPerThread Thread="0" ActualRows="2724" ActualEndOfScans="1" ActualExecutions="1" />
              </RunTimeInformation>
              <Parallelism>
                <RelOp AvgRowSize="1537" EstimateCPU="0.170218" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="635.468" LogicalOp="Inner Join" NodeId="1" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="12.8093">
                  <OutputList>
                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F0" />
                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F1" />
                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F7" />
                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F17" />
                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F33" />
                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F38" />
                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F50" />
                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F64" />
                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F82" />
                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict1]" Column="G2" />
                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict2]" Column="H2" />
                  </OutputList>
                  <MemoryFractions Input="0.579147" Output="1" />
                  <RunTimeInformation>
                    <RunTimeCountersPerThread Thread="21" ActualRows="133" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="22" ActualRows="118" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="24" ActualRows="126" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="11" ActualRows="92" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="12" ActualRows="101" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="23" ActualRows="101" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="2" ActualRows="127" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="5" ActualRows="106" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="8" ActualRows="114" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="20" ActualRows="119" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="16" ActualRows="113" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="19" ActualRows="91" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="13" ActualRows="92" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="17" ActualRows="103" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="18" ActualRows="122" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="14" ActualRows="118" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="15" ActualRows="101" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="7" ActualRows="126" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="10" ActualRows="126" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="6" ActualRows="115" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="1" ActualRows="126" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="3" ActualRows="111" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="4" ActualRows="112" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="9" ActualRows="131" ActualEndOfScans="1" ActualExecutions="1" />
                    <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                  </RunTimeInformation>
                  <Hash>
                    <DefinedValues />
                    <HashKeysBuild>
                      <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F11" />
                    </HashKeysBuild>
                    <HashKeysProbe>
                      <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict2]" Column="H1" />
                    </HashKeysProbe>
                    <RelOp AvgRowSize="1285" EstimateCPU="0.0328878" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="635.468" LogicalOp="Bitmap Create" NodeId="2" Parallel="true" PhysicalOp="Bitmap" EstimatedTotalSubtreeCost="12.3651">
                      <OutputList>
                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F0" />
                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F1" />
                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F7" />
                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F11" />
                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F17" />
                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F33" />
                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F38" />
                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F50" />
                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F64" />
                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F82" />
                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict1]" Column="G2" />
                      </OutputList>
                      <RunTimeInformation>
                        <RunTimeCountersPerThread Thread="22" ActualRows="118" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="21" ActualRows="133" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="23" ActualRows="101" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="24" ActualRows="126" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="12" ActualRows="101" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="5" ActualRows="106" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="11" ActualRows="92" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="2" ActualRows="127" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="8" ActualRows="114" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="20" ActualRows="119" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="19" ActualRows="91" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="18" ActualRows="122" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="17" ActualRows="103" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="16" ActualRows="113" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="15" ActualRows="101" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="14" ActualRows="118" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="13" ActualRows="92" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="7" ActualRows="126" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="1" ActualRows="126" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="6" ActualRows="115" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="4" ActualRows="112" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="9" ActualRows="131" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="10" ActualRows="126" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="3" ActualRows="111" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                      </RunTimeInformation>
                      <Bitmap>
                        <DefinedValues>
                          <DefinedValue>
                            <ColumnReference Column="Bitmap1010" />
                          </DefinedValue>
                        </DefinedValues>
                        <HashKeys>
                          <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F11" />
                        </HashKeys>
                        <RelOp AvgRowSize="1285" EstimateCPU="0.0328878" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="635.468" LogicalOp="Repartition Streams" NodeId="3" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="12.3651">
                          <OutputList>
                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F0" />
                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F1" />
                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F7" />
                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F11" />
                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F17" />
                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F33" />
                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F38" />
                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F50" />
                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F64" />
                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F82" />
                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict1]" Column="G2" />
                          </OutputList>
                          <RunTimeInformation>
                            <RunTimeCountersPerThread Thread="22" ActualRows="118" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="21" ActualRows="133" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="23" ActualRows="101" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="24" ActualRows="126" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="12" ActualRows="101" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="5" ActualRows="106" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="11" ActualRows="92" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="2" ActualRows="127" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="8" ActualRows="114" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="20" ActualRows="119" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="19" ActualRows="91" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="18" ActualRows="122" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="17" ActualRows="103" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="16" ActualRows="113" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="15" ActualRows="101" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="14" ActualRows="118" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="13" ActualRows="92" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="7" ActualRows="126" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="1" ActualRows="126" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="6" ActualRows="115" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="4" ActualRows="112" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="9" ActualRows="131" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="10" ActualRows="126" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="3" ActualRows="111" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                          </RunTimeInformation>
                          <Parallelism PartitioningType="Hash">
                            <PartitionColumns>
                              <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F11" />
                            </PartitionColumns>
                            <RelOp AvgRowSize="1285" EstimateCPU="0.319126" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="635.468" LogicalOp="Inner Join" NodeId="4" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="12.3322">
                              <OutputList>
                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F0" />
                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F1" />
                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F7" />
                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F11" />
                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F17" />
                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F33" />
                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F38" />
                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F50" />
                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F64" />
                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F82" />
                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict1]" Column="G2" />
                              </OutputList>
                              <MemoryFractions Input="1" Output="0.420853" />
                              <RunTimeInformation>
                                <RunTimeCountersPerThread Thread="23" ActualRows="91" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="22" ActualRows="64" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="21" ActualRows="90" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="20" ActualRows="107" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="8" ActualRows="121" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="10" ActualRows="75" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="9" ActualRows="168" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="7" ActualRows="90" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="18" ActualRows="141" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="4" ActualRows="123" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="24" ActualRows="89" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="19" ActualRows="106" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="17" ActualRows="165" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="6" ActualRows="137" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="11" ActualRows="96" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="5" ActualRows="111" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="12" ActualRows="113" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="16" ActualRows="112" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="14" ActualRows="186" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="15" ActualRows="98" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="13" ActualRows="103" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="1" ActualRows="127" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="3" ActualRows="98" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="2" ActualRows="113" ActualEndOfScans="1" ActualExecutions="1" />
                                <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                              </RunTimeInformation>
                              <Hash>
                                <DefinedValues />
                                <HashKeysBuild>
                                  <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F9" />
                                </HashKeysBuild>
                                <HashKeysProbe>
                                  <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict1]" Column="G1" />
                                </HashKeysProbe>
                                <RelOp AvgRowSize="837" EstimateCPU="0.031923" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="639.607" LogicalOp="Bitmap Create" NodeId="5" Parallel="true" PhysicalOp="Bitmap" EstimatedTotalSubtreeCost="11.8387">
                                  <OutputList>
                                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F0" />
                                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F1" />
                                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F7" />
                                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F9" />
                                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F11" />
                                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F17" />
                                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F33" />
                                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F38" />
                                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F50" />
                                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F64" />
                                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F82" />
                                  </OutputList>
                                  <RunTimeInformation>
                                    <RunTimeCountersPerThread Thread="23" ActualRows="91" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="8" ActualRows="121" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="22" ActualRows="64" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="21" ActualRows="90" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="20" ActualRows="107" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="9" ActualRows="168" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="10" ActualRows="75" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="7" ActualRows="90" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="4" ActualRows="123" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="24" ActualRows="89" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="18" ActualRows="141" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="19" ActualRows="106" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="17" ActualRows="165" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="11" ActualRows="96" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="6" ActualRows="137" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="5" ActualRows="111" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="12" ActualRows="113" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="14" ActualRows="186" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="16" ActualRows="112" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="13" ActualRows="103" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="15" ActualRows="98" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="1" ActualRows="127" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="3" ActualRows="98" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="2" ActualRows="113" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                  </RunTimeInformation>
                                  <Bitmap>
                                    <DefinedValues>
                                      <DefinedValue>
                                        <ColumnReference Column="Bitmap1009" />
                                      </DefinedValue>
                                    </DefinedValues>
                                    <HashKeys>
                                      <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F9" />
                                    </HashKeys>
                                    <RelOp AvgRowSize="837" EstimateCPU="0.031923" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="639.607" LogicalOp="Repartition Streams" NodeId="6" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="11.8387">
                                      <OutputList>
                                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F0" />
                                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F1" />
                                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F7" />
                                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F9" />
                                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F11" />
                                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F17" />
                                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F33" />
                                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F38" />
                                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F50" />
                                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F64" />
                                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F82" />
                                      </OutputList>
                                      <RunTimeInformation>
                                        <RunTimeCountersPerThread Thread="23" ActualRows="91" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="8" ActualRows="121" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="22" ActualRows="64" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="20" ActualRows="107" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="21" ActualRows="90" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="10" ActualRows="75" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="9" ActualRows="168" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="7" ActualRows="90" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="4" ActualRows="123" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="24" ActualRows="89" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="18" ActualRows="141" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="17" ActualRows="165" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="19" ActualRows="106" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="11" ActualRows="96" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="6" ActualRows="137" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="5" ActualRows="111" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="12" ActualRows="113" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="16" ActualRows="112" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="14" ActualRows="186" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="13" ActualRows="103" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="15" ActualRows="98" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="1" ActualRows="127" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="3" ActualRows="98" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="2" ActualRows="113" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                      </RunTimeInformation>
                                      <Parallelism PartitioningType="Hash">
                                        <PartitionColumns>
                                          <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F9" />
                                        </PartitionColumns>
                                        <RelOp AvgRowSize="839" EstimateCPU="0.0134717" EstimateIO="11.7691" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="639.607" LogicalOp="Clustered Index Scan" NodeId="7" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="11.7825" TableCardinality="146821">
                                          <OutputList>
                                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F0" />
                                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F1" />
                                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F7" />
                                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F9" />
                                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F11" />
                                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F17" />
                                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F33" />
                                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F38" />
                                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F50" />
                                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F64" />
                                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F82" />
                                          </OutputList>
                                          <RunTimeInformation>
                                            <RunTimeCountersPerThread Thread="23" ActualRows="134" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="11" ActualRows="103" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="1" ActualRows="115" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="21" ActualRows="107" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="24" ActualRows="122" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="18" ActualRows="97" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="20" ActualRows="122" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="22" ActualRows="108" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="12" ActualRows="97" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="17" ActualRows="105" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="5" ActualRows="93" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="19" ActualRows="102" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="6" ActualRows="114" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="16" ActualRows="114" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="15" ActualRows="111" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="13" ActualRows="109" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="14" ActualRows="96" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="10" ActualRows="127" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="9" ActualRows="150" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="4" ActualRows="95" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="7" ActualRows="106" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="8" ActualRows="118" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="3" ActualRows="124" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="2" ActualRows="155" ActualEndOfScans="1" ActualExecutions="1" />
                                            <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                          </RunTimeInformation>
                                          <IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false">
                                            <DefinedValues>
                                              <DefinedValue>
                                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F0" />
                                              </DefinedValue>
                                              <DefinedValue>
                                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F1" />
                                              </DefinedValue>
                                              <DefinedValue>
                                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F7" />
                                              </DefinedValue>
                                              <DefinedValue>
                                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F9" />
                                              </DefinedValue>
                                              <DefinedValue>
                                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F11" />
                                              </DefinedValue>
                                              <DefinedValue>
                                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F17" />
                                              </DefinedValue>
                                              <DefinedValue>
                                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F33" />
                                              </DefinedValue>
                                              <DefinedValue>
                                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F38" />
                                              </DefinedValue>
                                              <DefinedValue>
                                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F50" />
                                              </DefinedValue>
                                              <DefinedValue>
                                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F64" />
                                              </DefinedValue>
                                              <DefinedValue>
                                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F82" />
                                              </DefinedValue>
                                            </DefinedValues>
                                            <Object Database="[Stand]" Schema="[dbo]" Table="[Item]" Index="[PK_339902]" IndexKind="Clustered" />
                                            <Predicate>
                                              <ScalarOperator ScalarString="[Stand].[dbo].[Item].[F15]='Д' AND [Stand].[dbo].[Item].[F29]&lt;&gt;'A' AND [Stand].[dbo].[Item].[F50] IS NOT NULL AND NOT [Stand].[dbo].[Item].[F1] like '%/%/%'">
                                                <Logical Operation="AND">
                                                  <ScalarOperator>
                                                    <Compare CompareOp="EQ">
                                                      <ScalarOperator>
                                                        <Identifier>
                                                          <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F15" />
                                                        </Identifier>
                                                      </ScalarOperator>
                                                      <ScalarOperator>
                                                        <Const ConstValue="'Д'" />
                                                      </ScalarOperator>
                                                    </Compare>
                                                  </ScalarOperator>
                                                  <ScalarOperator>
                                                    <Compare CompareOp="NE">
                                                      <ScalarOperator>
                                                        <Identifier>
                                                          <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F29" />
                                                        </Identifier>
                                                      </ScalarOperator>
                                                      <ScalarOperator>
                                                        <Const ConstValue="'A'" />
                                                      </ScalarOperator>
                                                    </Compare>
                                                  </ScalarOperator>
                                                  <ScalarOperator>
                                                    <Compare CompareOp="IS NOT">
                                                      <ScalarOperator>
                                                        <Identifier>
                                                          <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F50" />
                                                        </Identifier>
                                                      </ScalarOperator>
                                                      <ScalarOperator>
                                                        <Const ConstValue="NULL" />
                                                      </ScalarOperator>
                                                    </Compare>
                                                  </ScalarOperator>
                                                  <ScalarOperator>
                                                    <Logical Operation="NOT">
                                                      <ScalarOperator>
                                                        <Intrinsic FunctionName="like">
                                                          <ScalarOperator>
                                                            <Identifier>
                                                              <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Item]" Column="F1" />
                                                            </Identifier>
                                                          </ScalarOperator>
                                                          <ScalarOperator>
                                                            <Const ConstValue="'%/%/%'" />
                                                          </ScalarOperator>
                                                        </Intrinsic>
                                                      </ScalarOperator>
                                                    </Logical>
                                                  </ScalarOperator>
                                                </Logical>
                                              </ScalarOperator>
                                            </Predicate>
                                          </IndexScan>
                                        </RelOp>
                                      </Parallelism>
                                    </RelOp>
                                  </Bitmap>
                                </RelOp>
                                <RelOp AvgRowSize="465" EstimateCPU="0.0857282" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="20077" LogicalOp="Repartition Streams" NodeId="8" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.17441">
                                  <OutputList>
                                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict1]" Column="G1" />
                                    <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict1]" Column="G2" />
                                  </OutputList>
                                  <RunTimeInformation>
                                    <RunTimeCountersPerThread Thread="23" ActualRows="44" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="8" ActualRows="46" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="22" ActualRows="36" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="20" ActualRows="48" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="21" ActualRows="49" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="9" ActualRows="61" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="10" ActualRows="41" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="7" ActualRows="53" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="4" ActualRows="40" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="18" ActualRows="45" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="24" ActualRows="51" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="17" ActualRows="45" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="19" ActualRows="43" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="11" ActualRows="43" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="6" ActualRows="48" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="5" ActualRows="37" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="12" ActualRows="52" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="14" ActualRows="40" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="16" ActualRows="46" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="13" ActualRows="47" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="15" ActualRows="45" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="1" ActualRows="54" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="3" ActualRows="41" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="2" ActualRows="56" ActualEndOfScans="1" ActualExecutions="1" />
                                    <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                  </RunTimeInformation>
                                  <Parallelism PartitioningType="Hash">
                                    <PartitionColumns>
                                      <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict1]" Column="G1" />
                                    </PartitionColumns>
                                    <RelOp AvgRowSize="465" EstimateCPU="0.00185348" EstimateIO="0.0868287" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="20077" LogicalOp="Index Scan" NodeId="9" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="0.0886822" TableCardinality="20077">
                                      <OutputList>
                                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict1]" Column="G1" />
                                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict1]" Column="G2" />
                                      </OutputList>
                                      <RunTimeInformation>
                                        <RunTimeCountersPerThread Thread="11" ActualRows="61" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="7" ActualRows="61" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="9" ActualRows="43" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="12" ActualRows="30" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="20" ActualRows="43" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="17" ActualRows="51" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="22" ActualRows="48" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="16" ActualRows="32" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="3" ActualRows="29" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="1" ActualRows="61" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="4" ActualRows="43" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="10" ActualRows="54" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="19" ActualRows="29" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="21" ActualRows="38" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="8" ActualRows="59" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="5" ActualRows="65" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="6" ActualRows="54" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="2" ActualRows="67" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="18" ActualRows="37" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="23" ActualRows="49" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="24" ActualRows="36" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="14" ActualRows="41" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="13" ActualRows="32" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="15" ActualRows="48" ActualEndOfScans="1" ActualExecutions="1" />
                                        <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                                      </RunTimeInformation>
                                      <IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
                                        <DefinedValues>
                                          <DefinedValue>
                                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict1]" Column="G1" />
                                          </DefinedValue>
                                          <DefinedValue>
                                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict1]" Column="G2" />
                                          </DefinedValue>
                                        </DefinedValues>
                                        <Object Database="[Stand]" Schema="[dbo]" Table="[Dict1]" Index="[C_1]" IndexKind="NonClustered" />
                                        <Predicate>
                                          <ScalarOperator ScalarString="PROBE([Bitmap1009],[Stand].[dbo].[Dict1].[G1],N'[IN ROW]')">
                                            <Intrinsic FunctionName="PROBE">
                                              <ScalarOperator>
                                                <Identifier>
                                                  <ColumnReference Column="Bitmap1009" />
                                                </Identifier>
                                              </ScalarOperator>
                                              <ScalarOperator>
                                                <Identifier>
                                                  <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict1]" Column="G1" />
                                                </Identifier>
                                              </ScalarOperator>
                                              <ScalarOperator>
                                                <Const ConstValue="N'[IN ROW]'" />
                                              </ScalarOperator>
                                            </Intrinsic>
                                          </ScalarOperator>
                                        </Predicate>
                                      </IndexScan>
                                    </RelOp>
                                  </Parallelism>
                                </RelOp>
                              </Hash>
                            </RelOp>
                          </Parallelism>
                        </RelOp>
                      </Bitmap>
                    </RelOp>
                    <RelOp AvgRowSize="269" EstimateCPU="0.0912245" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="36395" LogicalOp="Repartition Streams" NodeId="11" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.273995">
                      <OutputList>
                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict2]" Column="H1" />
                        <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict2]" Column="H2" />
                      </OutputList>
                      <RunTimeInformation>
                        <RunTimeCountersPerThread Thread="22" ActualRows="88" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="21" ActualRows="100" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="24" ActualRows="90" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="23" ActualRows="64" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="12" ActualRows="82" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="5" ActualRows="86" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="11" ActualRows="79" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="2" ActualRows="99" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="8" ActualRows="94" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="19" ActualRows="79" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="20" ActualRows="94" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="18" ActualRows="86" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="17" ActualRows="87" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="16" ActualRows="90" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="15" ActualRows="77" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="14" ActualRows="95" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="13" ActualRows="78" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="7" ActualRows="102" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="1" ActualRows="90" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="6" ActualRows="90" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="4" ActualRows="87" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="9" ActualRows="88" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="10" ActualRows="90" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="3" ActualRows="84" ActualEndOfScans="1" ActualExecutions="1" />
                        <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                      </RunTimeInformation>
                      <Parallelism PartitioningType="Hash">
                        <PartitionColumns>
                          <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict2]" Column="H1" />
                        </PartitionColumns>
                        <RelOp AvgRowSize="269" EstimateCPU="0.00334929" EstimateIO="0.179421" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="36395" LogicalOp="Index Scan" NodeId="12" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="0.182771" TableCardinality="36395">
                          <OutputList>
                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict2]" Column="H1" />
                            <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict2]" Column="H2" />
                          </OutputList>
                          <RunTimeInformation>
                            <RunTimeCountersPerThread Thread="24" ActualRows="55" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="19" ActualRows="63" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="1" ActualRows="73" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="21" ActualRows="47" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="20" ActualRows="64" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="23" ActualRows="71" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="14" ActualRows="82" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="22" ActualRows="80" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="17" ActualRows="120" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="10" ActualRows="92" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="11" ActualRows="100" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="6" ActualRows="92" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="9" ActualRows="73" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="8" ActualRows="88" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="12" ActualRows="66" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="16" ActualRows="113" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="18" ActualRows="151" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="15" ActualRows="85" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="2" ActualRows="106" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="7" ActualRows="76" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="13" ActualRows="98" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="5" ActualRows="101" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="3" ActualRows="117" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="4" ActualRows="86" ActualEndOfScans="1" ActualExecutions="1" />
                            <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                          </RunTimeInformation>
                          <IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
                            <DefinedValues>
                              <DefinedValue>
                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict2]" Column="H1" />
                              </DefinedValue>
                              <DefinedValue>
                                <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict2]" Column="H2" />
                              </DefinedValue>
                            </DefinedValues>
                            <Object Database="[Stand]" Schema="[dbo]" Table="[Dict2]" Index="[IX_42]" IndexKind="NonClustered" />
                            <Predicate>
                              <ScalarOperator ScalarString="PROBE([Bitmap1010],[Stand].[dbo].[Dict2].[H1],N'[IN ROW]')">
                                <Intrinsic FunctionName="PROBE">
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Column="Bitmap1010" />
                                    </Identifier>
                                  </ScalarOperator>
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Database="[Stand]" Schema="[dbo]" Table="[Dict2]" Column="H1" />
                                    </Identifier>
                                  </ScalarOperator>
                                  <ScalarOperator>
                                    <Const ConstValue="N'[IN ROW]'" />
                                  </ScalarOperator>
                                </Intrinsic>
                              </ScalarOperator>
                            </Predicate>
                          </IndexScan>
                        </RelOp>
                      </Parallelism>
                    </RelOp>
                  </Hash>
                </RelOp>
              </Parallelism>
            </RelOp>
          </QueryPlan>
        </StmtSimple>
      </Statements>
    </Batch>
  </BatchSequence>
</ShowPlanXML>

...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
26.10.2018, 15:22
    #39723577
aleks222
aleks222
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Блокировки после изменения размера поля
Алексей
Код: sql
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
Select 
dbo.Item.[F0],
dbo.Item.[F1],
dbo.Item.[F7],
dbo.Item.[F17],
dbo.Item.[F33],
dbo.Item.[F38],
dbo.Item.[F50],
dbo.Item.[F64],
dbo.Item.[F82],
dbo.Dict1.[G2],
dbo.Dict2.[H2]

from dbo.Item 
Inner  JOIN dbo.Dict1 ON dbo.Item.[F9] = dbo.Dict1.[G1]
Inner  JOIN dbo.Dict2 ON dbo.Item.[F11] = dbo.Dict2.[H1]
Where NOT(dbo.Item.[F1] Like '%/%/%') AND 
dbo.Item.[F50] IS not NULL
 AND
 (dbo.Item.[F15]='Д') AND NOT(dbo.Item.[F29]='A')





Чего тут загадочного?
Условия where сканируют ВСЮ таблицу. Индексы отдыхают.
Все нормально - так и должно быть.

ЗЫ.
Сколько строк dbo.Item подпадает под условие (dbo.Item.[F15]='Д')?
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
26.10.2018, 15:26
    #39723582
Алексей
Алексей
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Блокировки после изменения размера поля
aleks222,

Чуть более 25000
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
26.10.2018, 15:29
    #39723584
Алексей
Алексей
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Блокировки после изменения размера поля
aleks222,

То что запрос написан через одно место, это понятно.

До некоторых пор он работал нормально. Теперь при вызове этого запроса из Access (насколько я понимаю по трассировке) все виснут, а обладатель запущенного запроса преспокойно работает.

При этом sp_lock показывает большое количество Shared блокировок на страницу. А sp_who2 показывает несколько строк в которых показан этот запрос.
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
26.10.2018, 15:30
    #39723585
Алексей
Алексей
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Блокировки после изменения размера поля
aleks222,

И не знаю теперь что с этим делать.
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
26.10.2018, 15:38
    #39723588
aleks222
aleks222
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Блокировки после изменения размера поля
Алексейaleks222,

То что запрос написан через одно место, это понятно.

До некоторых пор он работал нормально. Теперь при вызове этого запроса из Access (насколько я понимаю по трассировке) все виснут, а обладатель запущенного запроса преспокойно работает.

При этом sp_lock показывает большое количество Shared блокировок на страницу. А sp_who2 показывает несколько строк в которых показан этот запрос.

1. Access, по умолчанию, открывает запрос в режиме "Динамический набор данных".
Вам точно нужна возможность редактировать 25 000 строк разом?

2. Какой тип подключения использует Access у вас?
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
26.10.2018, 16:36
    #39723649
Алексей
Алексей
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Блокировки после изменения размера поля
aleks222,

ODBC, если я правильно понял вопрос. здесь используется Access 2003, 2007
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
27.10.2018, 02:07
    #39723829
Massa52
Massa52
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Блокировки после изменения размера поля
Алексей,
Это было давно. У нас начались проблемы с аксессом 2003(mdе) при переходе с SQL 2000 на 2005.
Некоторые(я уже не помню точно какого типа) запросы, которые нормально отрабатывали на 2000 на 2005 зависали намертво.
Выкрутились только через вьюшки.
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
27.10.2018, 05:57
    #39723834
aleks222
aleks222
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Блокировки после изменения размера поля
Алексейaleks222,

ODBC, если я правильно понял вопрос. здесь используется Access 2003, 2007

По симптомам - у вас висит недофетченная выборка.

Уточним, на всякий случай:

1. Клиент Access просто открывает форму с источником данных в виде вашего запроса, подключенного через ODBC ?
2. Или вы врукопашную чего-то там в коде VBA открываете?
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
Форумы / Microsoft SQL Server [игнор отключен] [закрыт для гостей] / Блокировки после изменения размера поля / 19 сообщений из 19, страница 1 из 1
Найденые пользователи ...
Разблокировать пользователей ...
Читали тему (0):
Читали форум (0):
Пользователи онлайн (0):
x
x
Закрыть


Просмотр
0 / 0
Close
Debug Console [Select Text]