表上999个非聚集索引——你怎么看？

对于数据获取，如果查询优化器在执行计划里选择了索引，那么SQL Server里的每个索引可以提高你的查询性能。但在另一方面，每个索引也会伤及你的性能，因为在INSERT，UPDATE和DELETE期间，每个索引需要被维护。因此对于你的工作量，尽可能创建少的索引非常重要——不然在写操作期间，你会有巨大的性能问题。

当你在表上定义了最大999个索引，SQL Server会如何反应？我从未在表上创建多大999个索引，因此详细验证下这个行为，并讨论下它引入的所有副作用，会是个很好的锻炼。

我们来创建一个可怕的表！

下面代码向你展示如何创建一个真正可怕的表：我刚创建了999次一样的非聚集索引——反复执行。

   1 SET STATISTICS IO, TIME ON
   2 GO
   3 
   4 CREATE DATABASE TooMuchIndexes
   5 GO
   6 
   7 USE TooMuchIndexes
   8 GO
   9 
  10 -- Create a simple table
  11 CREATE TABLE PerformanceKiller
  12 (
  13     Col1 INT IDENTITY(1, 1) PRIMARY KEY NOT NULL,
  14     Col2 INT NOT NULL,
  15     Col3 CHAR(100) NOT NULL
  16 )
  17 GO
  18 
  19 -- Let's insert some data
  20 DECLARE @i INT = 1
  21 
  22 WHILE (@i < 100001)
  23 BEGIN
  24     INSERT INTO PerformanceKiller(Col2, Col3)
  25     VALUES (@i, REPLICATE('x', 100))
  26 
  27     SET @i += 1
  28 END
  29 GO
  30 
  31 -- Generates the DDL statement for all indexes
  32 DECLARE @i INT = 1
  33 
  34 WHILE (@i < 1000)
  35 BEGIN
  36     PRINT 'CREATE INDEX idx_StupidIndex' + CAST(@i AS VARCHAR(3)) + ' ON PerformanceKiller(Col2)'
  37     SET @i += 1
  38 END
  39 GO
  40 
  41 -- Create 999 Non-Clustered Indexes...
  42 CREATE INDEX idx_StupidIndex1 ON PerformanceKiller(Col2)
  43 CREATE INDEX idx_StupidIndex2 ON PerformanceKiller(Col2)
  44 CREATE INDEX idx_StupidIndex3 ON PerformanceKiller(Col2)
  45 CREATE INDEX idx_StupidIndex4 ON PerformanceKiller(Col2)
  46 CREATE INDEX idx_StupidIndex5 ON PerformanceKiller(Col2)
  47 CREATE INDEX idx_StupidIndex6 ON PerformanceKiller(Col2)
  48 CREATE INDEX idx_StupidIndex7 ON PerformanceKiller(Col2)
  49 CREATE INDEX idx_StupidIndex8 ON PerformanceKiller(Col2)
  50 CREATE INDEX idx_StupidIndex9 ON PerformanceKiller(Col2)
  51 CREATE INDEX idx_StupidIndex10 ON PerformanceKiller(Col2)
  52 CREATE INDEX idx_StupidIndex11 ON PerformanceKiller(Col2)
  53 CREATE INDEX idx_StupidIndex12 ON PerformanceKiller(Col2)
  54 CREATE INDEX idx_StupidIndex13 ON PerformanceKiller(Col2)
  55 CREATE INDEX idx_StupidIndex14 ON PerformanceKiller(Col2)
  56 CREATE INDEX idx_StupidIndex15 ON PerformanceKiller(Col2)
  57 CREATE INDEX idx_StupidIndex16 ON PerformanceKiller(Col2)
  58 CREATE INDEX idx_StupidIndex17 ON PerformanceKiller(Col2)
  59 CREATE INDEX idx_StupidIndex18 ON PerformanceKiller(Col2)
  60 CREATE INDEX idx_StupidIndex19 ON PerformanceKiller(Col2)
  61 CREATE INDEX idx_StupidIndex20 ON PerformanceKiller(Col2)
  62 CREATE INDEX idx_StupidIndex21 ON PerformanceKiller(Col2)
  63 CREATE INDEX idx_StupidIndex22 ON PerformanceKiller(Col2)
  64 CREATE INDEX idx_StupidIndex23 ON PerformanceKiller(Col2)
  65 CREATE INDEX idx_StupidIndex24 ON PerformanceKiller(Col2)
  66 CREATE INDEX idx_StupidIndex25 ON PerformanceKiller(Col2)
  67 CREATE INDEX idx_StupidIndex26 ON PerformanceKiller(Col2)
  68 CREATE INDEX idx_StupidIndex27 ON PerformanceKiller(Col2)
  69 CREATE INDEX idx_StupidIndex28 ON PerformanceKiller(Col2)
  70 CREATE INDEX idx_StupidIndex29 ON PerformanceKiller(Col2)
  71 CREATE INDEX idx_StupidIndex30 ON PerformanceKiller(Col2)
  72 CREATE INDEX idx_StupidIndex31 ON PerformanceKiller(Col2)
  73 CREATE INDEX idx_StupidIndex32 ON PerformanceKiller(Col2)
  74 CREATE INDEX idx_StupidIndex33 ON PerformanceKiller(Col2)
  75 CREATE INDEX idx_StupidIndex34 ON PerformanceKiller(Col2)
  76 CREATE INDEX idx_StupidIndex35 ON PerformanceKiller(Col2)
  77 CREATE INDEX idx_StupidIndex36 ON PerformanceKiller(Col2)
  78 CREATE INDEX idx_StupidIndex37 ON PerformanceKiller(Col2)
  79 CREATE INDEX idx_StupidIndex38 ON PerformanceKiller(Col2)
  80 CREATE INDEX idx_StupidIndex39 ON PerformanceKiller(Col2)
  81 CREATE INDEX idx_StupidIndex40 ON PerformanceKiller(Col2)
  82 CREATE INDEX idx_StupidIndex41 ON PerformanceKiller(Col2)
  83 CREATE INDEX idx_StupidIndex42 ON PerformanceKiller(Col2)
  84 CREATE INDEX idx_StupidIndex43 ON PerformanceKiller(Col2)
  85 CREATE INDEX idx_StupidIndex44 ON PerformanceKiller(Col2)
  86 CREATE INDEX idx_StupidIndex45 ON PerformanceKiller(Col2)
  87 CREATE INDEX idx_StupidIndex46 ON PerformanceKiller(Col2)
  88 CREATE INDEX idx_StupidIndex47 ON PerformanceKiller(Col2)
  89 CREATE INDEX idx_StupidIndex48 ON PerformanceKiller(Col2)
  90 CREATE INDEX idx_StupidIndex49 ON PerformanceKiller(Col2)
  91 CREATE INDEX idx_StupidIndex50 ON PerformanceKiller(Col2)
  92 CREATE INDEX idx_StupidIndex51 ON PerformanceKiller(Col2)
  93 CREATE INDEX idx_StupidIndex52 ON PerformanceKiller(Col2)
  94 CREATE INDEX idx_StupidIndex53 ON PerformanceKiller(Col2)
  95 CREATE INDEX idx_StupidIndex54 ON PerformanceKiller(Col2)
  96 CREATE INDEX idx_StupidIndex55 ON PerformanceKiller(Col2)
  97 CREATE INDEX idx_StupidIndex56 ON PerformanceKiller(Col2)
  98 CREATE INDEX idx_StupidIndex57 ON PerformanceKiller(Col2)
  99 CREATE INDEX idx_StupidIndex58 ON PerformanceKiller(Col2)
 100 CREATE INDEX idx_StupidIndex59 ON PerformanceKiller(Col2)
 101 CREATE INDEX idx_StupidIndex60 ON PerformanceKiller(Col2)
 102 CREATE INDEX idx_StupidIndex61 ON PerformanceKiller(Col2)
 103 CREATE INDEX idx_StupidIndex62 ON PerformanceKiller(Col2)
 104 CREATE INDEX idx_StupidIndex63 ON PerformanceKiller(Col2)
 105 CREATE INDEX idx_StupidIndex64 ON PerformanceKiller(Col2)
 106 CREATE INDEX idx_StupidIndex65 ON PerformanceKiller(Col2)
 107 CREATE INDEX idx_StupidIndex66 ON PerformanceKiller(Col2)
 108 CREATE INDEX idx_StupidIndex67 ON PerformanceKiller(Col2)
 109 CREATE INDEX idx_StupidIndex68 ON PerformanceKiller(Col2)
 110 CREATE INDEX idx_StupidIndex69 ON PerformanceKiller(Col2)
 111 CREATE INDEX idx_StupidIndex70 ON PerformanceKiller(Col2)
 112 CREATE INDEX idx_StupidIndex71 ON PerformanceKiller(Col2)
 113 CREATE INDEX idx_StupidIndex72 ON PerformanceKiller(Col2)
 114 CREATE INDEX idx_StupidIndex73 ON PerformanceKiller(Col2)
 115 CREATE INDEX idx_StupidIndex74 ON PerformanceKiller(Col2)
 116 CREATE INDEX idx_StupidIndex75 ON PerformanceKiller(Col2)
 117 CREATE INDEX idx_StupidIndex76 ON PerformanceKiller(Col2)
 118 CREATE INDEX idx_StupidIndex77 ON PerformanceKiller(Col2)
 119 CREATE INDEX idx_StupidIndex78 ON PerformanceKiller(Col2)
 120 CREATE INDEX idx_StupidIndex79 ON PerformanceKiller(Col2)
 121 CREATE INDEX idx_StupidIndex80 ON PerformanceKiller(Col2)
 122 CREATE INDEX idx_StupidIndex81 ON PerformanceKiller(Col2)
 123 CREATE INDEX idx_StupidIndex82 ON PerformanceKiller(Col2)
 124 CREATE INDEX idx_StupidIndex83 ON PerformanceKiller(Col2)
 125 CREATE INDEX idx_StupidIndex84 ON PerformanceKiller(Col2)
 126 CREATE INDEX idx_StupidIndex85 ON PerformanceKiller(Col2)
 127 CREATE INDEX idx_StupidIndex86 ON PerformanceKiller(Col2)
 128 CREATE INDEX idx_StupidIndex87 ON PerformanceKiller(Col2)
 129 CREATE INDEX idx_StupidIndex88 ON PerformanceKiller(Col2)
 130 CREATE INDEX idx_StupidIndex89 ON PerformanceKiller(Col2)
 131 CREATE INDEX idx_StupidIndex90 ON PerformanceKiller(Col2)
 132 CREATE INDEX idx_StupidIndex91 ON PerformanceKiller(Col2)
 133 CREATE INDEX idx_StupidIndex92 ON PerformanceKiller(Col2)
 134 CREATE INDEX idx_StupidIndex93 ON PerformanceKiller(Col2)
 135 CREATE INDEX idx_StupidIndex94 ON PerformanceKiller(Col2)
 136 CREATE INDEX idx_StupidIndex95 ON PerformanceKiller(Col2)
 137 CREATE INDEX idx_StupidIndex96 ON PerformanceKiller(Col2)
 138 CREATE INDEX idx_StupidIndex97 ON PerformanceKiller(Col2)
 139 CREATE INDEX idx_StupidIndex98 ON PerformanceKiller(Col2)
 140 CREATE INDEX idx_StupidIndex99 ON PerformanceKiller(Col2)
 141 CREATE INDEX idx_StupidIndex100 ON PerformanceKiller(Col2)
 142 CREATE INDEX idx_StupidIndex101 ON PerformanceKiller(Col2)
 143 CREATE INDEX idx_StupidIndex102 ON PerformanceKiller(Col2)
 144 CREATE INDEX idx_StupidIndex103 ON PerformanceKiller(Col2)
 145 CREATE INDEX idx_StupidIndex104 ON PerformanceKiller(Col2)
 146 CREATE INDEX idx_StupidIndex105 ON PerformanceKiller(Col2)
 147 CREATE INDEX idx_StupidIndex106 ON PerformanceKiller(Col2)
 148 CREATE INDEX idx_StupidIndex107 ON PerformanceKiller(Col2)
 149 CREATE INDEX idx_StupidIndex108 ON PerformanceKiller(Col2)
 150 CREATE INDEX idx_StupidIndex109 ON PerformanceKiller(Col2)
 151 CREATE INDEX idx_StupidIndex110 ON PerformanceKiller(Col2)
 152 CREATE INDEX idx_StupidIndex111 ON PerformanceKiller(Col2)
 153 CREATE INDEX idx_StupidIndex112 ON PerformanceKiller(Col2)
 154 CREATE INDEX idx_StupidIndex113 ON PerformanceKiller(Col2)
 155 CREATE INDEX idx_StupidIndex114 ON PerformanceKiller(Col2)
 156 CREATE INDEX idx_StupidIndex115 ON PerformanceKiller(Col2)
 157 CREATE INDEX idx_StupidIndex116 ON PerformanceKiller(Col2)
 158 CREATE INDEX idx_StupidIndex117 ON PerformanceKiller(Col2)
 159 CREATE INDEX idx_StupidIndex118 ON PerformanceKiller(Col2)
 160 CREATE INDEX idx_StupidIndex119 ON PerformanceKiller(Col2)
 161 CREATE INDEX idx_StupidIndex120 ON PerformanceKiller(Col2)
 162 CREATE INDEX idx_StupidIndex121 ON PerformanceKiller(Col2)
 163 CREATE INDEX idx_StupidIndex122 ON PerformanceKiller(Col2)
 164 CREATE INDEX idx_StupidIndex123 ON PerformanceKiller(Col2)
 165 CREATE INDEX idx_StupidIndex124 ON PerformanceKiller(Col2)
 166 CREATE INDEX idx_StupidIndex125 ON PerformanceKiller(Col2)
 167 CREATE INDEX idx_StupidIndex126 ON PerformanceKiller(Col2)
 168 CREATE INDEX idx_StupidIndex127 ON PerformanceKiller(Col2)
 169 CREATE INDEX idx_StupidIndex128 ON PerformanceKiller(Col2)
 170 CREATE INDEX idx_StupidIndex129 ON PerformanceKiller(Col2)
 171 CREATE INDEX idx_StupidIndex130 ON PerformanceKiller(Col2)
 172 CREATE INDEX idx_StupidIndex131 ON PerformanceKiller(Col2)
 173 CREATE INDEX idx_StupidIndex132 ON PerformanceKiller(Col2)
 174 CREATE INDEX idx_StupidIndex133 ON PerformanceKiller(Col2)
 175 CREATE INDEX idx_StupidIndex134 ON PerformanceKiller(Col2)
 176 CREATE INDEX idx_StupidIndex135 ON PerformanceKiller(Col2)
 177 CREATE INDEX idx_StupidIndex136 ON PerformanceKiller(Col2)
 178 CREATE INDEX idx_StupidIndex137 ON PerformanceKiller(Col2)
 179 CREATE INDEX idx_StupidIndex138 ON PerformanceKiller(Col2)
 180 CREATE INDEX idx_StupidIndex139 ON PerformanceKiller(Col2)
 181 CREATE INDEX idx_StupidIndex140 ON PerformanceKiller(Col2)
 182 CREATE INDEX idx_StupidIndex141 ON PerformanceKiller(Col2)
 183 CREATE INDEX idx_StupidIndex142 ON PerformanceKiller(Col2)
 184 CREATE INDEX idx_StupidIndex143 ON PerformanceKiller(Col2)
 185 CREATE INDEX idx_StupidIndex144 ON PerformanceKiller(Col2)
 186 CREATE INDEX idx_StupidIndex145 ON PerformanceKiller(Col2)
 187 CREATE INDEX idx_StupidIndex146 ON PerformanceKiller(Col2)
 188 CREATE INDEX idx_StupidIndex147 ON PerformanceKiller(Col2)
 189 CREATE INDEX idx_StupidIndex148 ON PerformanceKiller(Col2)
 190 CREATE INDEX idx_StupidIndex149 ON PerformanceKiller(Col2)
 191 CREATE INDEX idx_StupidIndex150 ON PerformanceKiller(Col2)
 192 CREATE INDEX idx_StupidIndex151 ON PerformanceKiller(Col2)
 193 CREATE INDEX idx_StupidIndex152 ON PerformanceKiller(Col2)
 194 CREATE INDEX idx_StupidIndex153 ON PerformanceKiller(Col2)
 195 CREATE INDEX idx_StupidIndex154 ON PerformanceKiller(Col2)
 196 CREATE INDEX idx_StupidIndex155 ON PerformanceKiller(Col2)
 197 CREATE INDEX idx_StupidIndex156 ON PerformanceKiller(Col2)
 198 CREATE INDEX idx_StupidIndex157 ON PerformanceKiller(Col2)
 199 CREATE INDEX idx_StupidIndex158 ON PerformanceKiller(Col2)
 200 CREATE INDEX idx_StupidIndex159 ON PerformanceKiller(Col2)
 201 CREATE INDEX idx_StupidIndex160 ON PerformanceKiller(Col2)
 202 CREATE INDEX idx_StupidIndex161 ON PerformanceKiller(Col2)
 203 CREATE INDEX idx_StupidIndex162 ON PerformanceKiller(Col2)
 204 CREATE INDEX idx_StupidIndex163 ON PerformanceKiller(Col2)
 205 CREATE INDEX idx_StupidIndex164 ON PerformanceKiller(Col2)
 206 CREATE INDEX idx_StupidIndex165 ON PerformanceKiller(Col2)
 207 CREATE INDEX idx_StupidIndex166 ON PerformanceKiller(Col2)
 208 CREATE INDEX idx_StupidIndex167 ON PerformanceKiller(Col2)
 209 CREATE INDEX idx_StupidIndex168 ON PerformanceKiller(Col2)
 210 CREATE INDEX idx_StupidIndex169 ON PerformanceKiller(Col2)
 211 CREATE INDEX idx_StupidIndex170 ON PerformanceKiller(Col2)
 212 CREATE INDEX idx_StupidIndex171 ON PerformanceKiller(Col2)
 213 CREATE INDEX idx_StupidIndex172 ON PerformanceKiller(Col2)
 214 CREATE INDEX idx_StupidIndex173 ON PerformanceKiller(Col2)
 215 CREATE INDEX idx_StupidIndex174 ON PerformanceKiller(Col2)
 216 CREATE INDEX idx_StupidIndex175 ON PerformanceKiller(Col2)
 217 CREATE INDEX idx_StupidIndex176 ON PerformanceKiller(Col2)
 218 CREATE INDEX idx_StupidIndex177 ON PerformanceKiller(Col2)
 219 CREATE INDEX idx_StupidIndex178 ON PerformanceKiller(Col2)
 220 CREATE INDEX idx_StupidIndex179 ON PerformanceKiller(Col2)
 221 CREATE INDEX idx_StupidIndex180 ON PerformanceKiller(Col2)
 222 CREATE INDEX idx_StupidIndex181 ON PerformanceKiller(Col2)
 223 CREATE INDEX idx_StupidIndex182 ON PerformanceKiller(Col2)
 224 CREATE INDEX idx_StupidIndex183 ON PerformanceKiller(Col2)
 225 CREATE INDEX idx_StupidIndex184 ON PerformanceKiller(Col2)
 226 CREATE INDEX idx_StupidIndex185 ON PerformanceKiller(Col2)
 227 CREATE INDEX idx_StupidIndex186 ON PerformanceKiller(Col2)
 228 CREATE INDEX idx_StupidIndex187 ON PerformanceKiller(Col2)
 229 CREATE INDEX idx_StupidIndex188 ON PerformanceKiller(Col2)
 230 CREATE INDEX idx_StupidIndex189 ON PerformanceKiller(Col2)
 231 CREATE INDEX idx_StupidIndex190 ON PerformanceKiller(Col2)
 232 CREATE INDEX idx_StupidIndex191 ON PerformanceKiller(Col2)
 233 CREATE INDEX idx_StupidIndex192 ON PerformanceKiller(Col2)
 234 CREATE INDEX idx_StupidIndex193 ON PerformanceKiller(Col2)
 235 CREATE INDEX idx_StupidIndex194 ON PerformanceKiller(Col2)
 236 CREATE INDEX idx_StupidIndex195 ON PerformanceKiller(Col2)
 237 CREATE INDEX idx_StupidIndex196 ON PerformanceKiller(Col2)
 238 CREATE INDEX idx_StupidIndex197 ON PerformanceKiller(Col2)
 239 CREATE INDEX idx_StupidIndex198 ON PerformanceKiller(Col2)
 240 CREATE INDEX idx_StupidIndex199 ON PerformanceKiller(Col2)
 241 CREATE INDEX idx_StupidIndex200 ON PerformanceKiller(Col2)
 242 CREATE INDEX idx_StupidIndex201 ON PerformanceKiller(Col2)
 243 CREATE INDEX idx_StupidIndex202 ON PerformanceKiller(Col2)
 244 CREATE INDEX idx_StupidIndex203 ON PerformanceKiller(Col2)
 245 CREATE INDEX idx_StupidIndex204 ON PerformanceKiller(Col2)
 246 CREATE INDEX idx_StupidIndex205 ON PerformanceKiller(Col2)
 247 CREATE INDEX idx_StupidIndex206 ON PerformanceKiller(Col2)
 248 CREATE INDEX idx_StupidIndex207 ON PerformanceKiller(Col2)
 249 CREATE INDEX idx_StupidIndex208 ON PerformanceKiller(Col2)
 250 CREATE INDEX idx_StupidIndex209 ON PerformanceKiller(Col2)
 251 CREATE INDEX idx_StupidIndex210 ON PerformanceKiller(Col2)
 252 CREATE INDEX idx_StupidIndex211 ON PerformanceKiller(Col2)
 253 CREATE INDEX idx_StupidIndex212 ON PerformanceKiller(Col2)
 254 CREATE INDEX idx_StupidIndex213 ON PerformanceKiller(Col2)
 255 CREATE INDEX idx_StupidIndex214 ON PerformanceKiller(Col2)
 256 CREATE INDEX idx_StupidIndex215 ON PerformanceKiller(Col2)
 257 CREATE INDEX idx_StupidIndex216 ON PerformanceKiller(Col2)
 258 CREATE INDEX idx_StupidIndex217 ON PerformanceKiller(Col2)
 259 CREATE INDEX idx_StupidIndex218 ON PerformanceKiller(Col2)
 260 CREATE INDEX idx_StupidIndex219 ON PerformanceKiller(Col2)
 261 CREATE INDEX idx_StupidIndex220 ON PerformanceKiller(Col2)
 262 CREATE INDEX idx_StupidIndex221 ON PerformanceKiller(Col2)
 263 CREATE INDEX idx_StupidIndex222 ON PerformanceKiller(Col2)
 264 CREATE INDEX idx_StupidIndex223 ON PerformanceKiller(Col2)
 265 CREATE INDEX idx_StupidIndex224 ON PerformanceKiller(Col2)
 266 CREATE INDEX idx_StupidIndex225 ON PerformanceKiller(Col2)
 267 CREATE INDEX idx_StupidIndex226 ON PerformanceKiller(Col2)
 268 CREATE INDEX idx_StupidIndex227 ON PerformanceKiller(Col2)
 269 CREATE INDEX idx_StupidIndex228 ON PerformanceKiller(Col2)
 270 CREATE INDEX idx_StupidIndex229 ON PerformanceKiller(Col2)
 271 CREATE INDEX idx_StupidIndex230 ON PerformanceKiller(Col2)
 272 CREATE INDEX idx_StupidIndex231 ON PerformanceKiller(Col2)
 273 CREATE INDEX idx_StupidIndex232 ON PerformanceKiller(Col2)
 274 CREATE INDEX idx_StupidIndex233 ON PerformanceKiller(Col2)
 275 CREATE INDEX idx_StupidIndex234 ON PerformanceKiller(Col2)
 276 CREATE INDEX idx_StupidIndex235 ON PerformanceKiller(Col2)
 277 CREATE INDEX idx_StupidIndex236 ON PerformanceKiller(Col2)
 278 CREATE INDEX idx_StupidIndex237 ON PerformanceKiller(Col2)
 279 CREATE INDEX idx_StupidIndex238 ON PerformanceKiller(Col2)
 280 CREATE INDEX idx_StupidIndex239 ON PerformanceKiller(Col2)
 281 CREATE INDEX idx_StupidIndex240 ON PerformanceKiller(Col2)
 282 CREATE INDEX idx_StupidIndex241 ON PerformanceKiller(Col2)
 283 CREATE INDEX idx_StupidIndex242 ON PerformanceKiller(Col2)
 284 CREATE INDEX idx_StupidIndex243 ON PerformanceKiller(Col2)
 285 CREATE INDEX idx_StupidIndex244 ON PerformanceKiller(Col2)
 286 CREATE INDEX idx_StupidIndex245 ON PerformanceKiller(Col2)
 287 CREATE INDEX idx_StupidIndex246 ON PerformanceKiller(Col2)
 288 CREATE INDEX idx_StupidIndex247 ON PerformanceKiller(Col2)
 289 CREATE INDEX idx_StupidIndex248 ON PerformanceKiller(Col2)
 290 CREATE INDEX idx_StupidIndex249 ON PerformanceKiller(Col2)
 291 CREATE INDEX idx_StupidIndex250 ON PerformanceKiller(Col2)
 292 CREATE INDEX idx_StupidIndex251 ON PerformanceKiller(Col2)
 293 CREATE INDEX idx_StupidIndex252 ON PerformanceKiller(Col2)
 294 CREATE INDEX idx_StupidIndex253 ON PerformanceKiller(Col2)
 295 CREATE INDEX idx_StupidIndex254 ON PerformanceKiller(Col2)
 296 CREATE INDEX idx_StupidIndex255 ON PerformanceKiller(Col2)
 297 CREATE INDEX idx_StupidIndex256 ON PerformanceKiller(Col2)
 298 CREATE INDEX idx_StupidIndex257 ON PerformanceKiller(Col2)
 299 CREATE INDEX idx_StupidIndex258 ON PerformanceKiller(Col2)
 300 CREATE INDEX idx_StupidIndex259 ON PerformanceKiller(Col2)
 301 CREATE INDEX idx_StupidIndex260 ON PerformanceKiller(Col2)
 302 CREATE INDEX idx_StupidIndex261 ON PerformanceKiller(Col2)
 303 CREATE INDEX idx_StupidIndex262 ON PerformanceKiller(Col2)
 304 CREATE INDEX idx_StupidIndex263 ON PerformanceKiller(Col2)
 305 CREATE INDEX idx_StupidIndex264 ON PerformanceKiller(Col2)
 306 CREATE INDEX idx_StupidIndex265 ON PerformanceKiller(Col2)
 307 CREATE INDEX idx_StupidIndex266 ON PerformanceKiller(Col2)
 308 CREATE INDEX idx_StupidIndex267 ON PerformanceKiller(Col2)
 309 CREATE INDEX idx_StupidIndex268 ON PerformanceKiller(Col2)
 310 CREATE INDEX idx_StupidIndex269 ON PerformanceKiller(Col2)
 311 CREATE INDEX idx_StupidIndex270 ON PerformanceKiller(Col2)
 312 CREATE INDEX idx_StupidIndex271 ON PerformanceKiller(Col2)
 313 CREATE INDEX idx_StupidIndex272 ON PerformanceKiller(Col2)
 314 CREATE INDEX idx_StupidIndex273 ON PerformanceKiller(Col2)
 315 CREATE INDEX idx_StupidIndex274 ON PerformanceKiller(Col2)
 316 CREATE INDEX idx_StupidIndex275 ON PerformanceKiller(Col2)
 317 CREATE INDEX idx_StupidIndex276 ON PerformanceKiller(Col2)
 318 CREATE INDEX idx_StupidIndex277 ON PerformanceKiller(Col2)
 319 CREATE INDEX idx_StupidIndex278 ON PerformanceKiller(Col2)
 320 CREATE INDEX idx_StupidIndex279 ON PerformanceKiller(Col2)
 321 CREATE INDEX idx_StupidIndex280 ON PerformanceKiller(Col2)
 322 CREATE INDEX idx_StupidIndex281 ON PerformanceKiller(Col2)
 323 CREATE INDEX idx_StupidIndex282 ON PerformanceKiller(Col2)
 324 CREATE INDEX idx_StupidIndex283 ON PerformanceKiller(Col2)
 325 CREATE INDEX idx_StupidIndex284 ON PerformanceKiller(Col2)
 326 CREATE INDEX idx_StupidIndex285 ON PerformanceKiller(Col2)
 327 CREATE INDEX idx_StupidIndex286 ON PerformanceKiller(Col2)
 328 CREATE INDEX idx_StupidIndex287 ON PerformanceKiller(Col2)
 329 CREATE INDEX idx_StupidIndex288 ON PerformanceKiller(Col2)
 330 CREATE INDEX idx_StupidIndex289 ON PerformanceKiller(Col2)
 331 CREATE INDEX idx_StupidIndex290 ON PerformanceKiller(Col2)
 332 CREATE INDEX idx_StupidIndex291 ON PerformanceKiller(Col2)
 333 CREATE INDEX idx_StupidIndex292 ON PerformanceKiller(Col2)
 334 CREATE INDEX idx_StupidIndex293 ON PerformanceKiller(Col2)
 335 CREATE INDEX idx_StupidIndex294 ON PerformanceKiller(Col2)
 336 CREATE INDEX idx_StupidIndex295 ON PerformanceKiller(Col2)
 337 CREATE INDEX idx_StupidIndex296 ON PerformanceKiller(Col2)
 338 CREATE INDEX idx_StupidIndex297 ON PerformanceKiller(Col2)
 339 CREATE INDEX idx_StupidIndex298 ON PerformanceKiller(Col2)
 340 CREATE INDEX idx_StupidIndex299 ON PerformanceKiller(Col2)
 341 CREATE INDEX idx_StupidIndex300 ON PerformanceKiller(Col2)
 342 CREATE INDEX idx_StupidIndex301 ON PerformanceKiller(Col2)
 343 CREATE INDEX idx_StupidIndex302 ON PerformanceKiller(Col2)
 344 CREATE INDEX idx_StupidIndex303 ON PerformanceKiller(Col2)
 345 CREATE INDEX idx_StupidIndex304 ON PerformanceKiller(Col2)
 346 CREATE INDEX idx_StupidIndex305 ON PerformanceKiller(Col2)
 347 CREATE INDEX idx_StupidIndex306 ON PerformanceKiller(Col2)
 348 CREATE INDEX idx_StupidIndex307 ON PerformanceKiller(Col2)
 349 CREATE INDEX idx_StupidIndex308 ON PerformanceKiller(Col2)
 350 CREATE INDEX idx_StupidIndex309 ON PerformanceKiller(Col2)
 351 CREATE INDEX idx_StupidIndex310 ON PerformanceKiller(Col2)
 352 CREATE INDEX idx_StupidIndex311 ON PerformanceKiller(Col2)
 353 CREATE INDEX idx_StupidIndex312 ON PerformanceKiller(Col2)
 354 CREATE INDEX idx_StupidIndex313 ON PerformanceKiller(Col2)
 355 CREATE INDEX idx_StupidIndex314 ON PerformanceKiller(Col2)
 356 CREATE INDEX idx_StupidIndex315 ON PerformanceKiller(Col2)
 357 CREATE INDEX idx_StupidIndex316 ON PerformanceKiller(Col2)
 358 CREATE INDEX idx_StupidIndex317 ON PerformanceKiller(Col2)
 359 CREATE INDEX idx_StupidIndex318 ON PerformanceKiller(Col2)
 360 CREATE INDEX idx_StupidIndex319 ON PerformanceKiller(Col2)
 361 CREATE INDEX idx_StupidIndex320 ON PerformanceKiller(Col2)
 362 CREATE INDEX idx_StupidIndex321 ON PerformanceKiller(Col2)
 363 CREATE INDEX idx_StupidIndex322 ON PerformanceKiller(Col2)
 364 CREATE INDEX idx_StupidIndex323 ON PerformanceKiller(Col2)
 365 CREATE INDEX idx_StupidIndex324 ON PerformanceKiller(Col2)
 366 CREATE INDEX idx_StupidIndex325 ON PerformanceKiller(Col2)
 367 CREATE INDEX idx_StupidIndex326 ON PerformanceKiller(Col2)
 368 CREATE INDEX idx_StupidIndex327 ON PerformanceKiller(Col2)
 369 CREATE INDEX idx_StupidIndex328 ON PerformanceKiller(Col2)
 370 CREATE INDEX idx_StupidIndex329 ON PerformanceKiller(Col2)
 371 CREATE INDEX idx_StupidIndex330 ON PerformanceKiller(Col2)
 372 CREATE INDEX idx_StupidIndex331 ON PerformanceKiller(Col2)
 373 CREATE INDEX idx_StupidIndex332 ON PerformanceKiller(Col2)
 374 CREATE INDEX idx_StupidIndex333 ON PerformanceKiller(Col2)
 375 CREATE INDEX idx_StupidIndex334 ON PerformanceKiller(Col2)
 376 CREATE INDEX idx_StupidIndex335 ON PerformanceKiller(Col2)
 377 CREATE INDEX idx_StupidIndex336 ON PerformanceKiller(Col2)
 378 CREATE INDEX idx_StupidIndex337 ON PerformanceKiller(Col2)
 379 CREATE INDEX idx_StupidIndex338 ON PerformanceKiller(Col2)
 380 CREATE INDEX idx_StupidIndex339 ON PerformanceKiller(Col2)
 381 CREATE INDEX idx_StupidIndex340 ON PerformanceKiller(Col2)
 382 CREATE INDEX idx_StupidIndex341 ON PerformanceKiller(Col2)
 383 CREATE INDEX idx_StupidIndex342 ON PerformanceKiller(Col2)
 384 CREATE INDEX idx_StupidIndex343 ON PerformanceKiller(Col2)
 385 CREATE INDEX idx_StupidIndex344 ON PerformanceKiller(Col2)
 386 CREATE INDEX idx_StupidIndex345 ON PerformanceKiller(Col2)
 387 CREATE INDEX idx_StupidIndex346 ON PerformanceKiller(Col2)
 388 CREATE INDEX idx_StupidIndex347 ON PerformanceKiller(Col2)
 389 CREATE INDEX idx_StupidIndex348 ON PerformanceKiller(Col2)
 390 CREATE INDEX idx_StupidIndex349 ON PerformanceKiller(Col2)
 391 CREATE INDEX idx_StupidIndex350 ON PerformanceKiller(Col2)
 392 CREATE INDEX idx_StupidIndex351 ON PerformanceKiller(Col2)
 393 CREATE INDEX idx_StupidIndex352 ON PerformanceKiller(Col2)
 394 CREATE INDEX idx_StupidIndex353 ON PerformanceKiller(Col2)
 395 CREATE INDEX idx_StupidIndex354 ON PerformanceKiller(Col2)
 396 CREATE INDEX idx_StupidIndex355 ON PerformanceKiller(Col2)
 397 CREATE INDEX idx_StupidIndex356 ON PerformanceKiller(Col2)
 398 CREATE INDEX idx_StupidIndex357 ON PerformanceKiller(Col2)
 399 CREATE INDEX idx_StupidIndex358 ON PerformanceKiller(Col2)
 400 CREATE INDEX idx_StupidIndex359 ON PerformanceKiller(Col2)
 401 CREATE INDEX idx_StupidIndex360 ON PerformanceKiller(Col2)
 402 CREATE INDEX idx_StupidIndex361 ON PerformanceKiller(Col2)
 403 CREATE INDEX idx_StupidIndex362 ON PerformanceKiller(Col2)
 404 CREATE INDEX idx_StupidIndex363 ON PerformanceKiller(Col2)
 405 CREATE INDEX idx_StupidIndex364 ON PerformanceKiller(Col2)
 406 CREATE INDEX idx_StupidIndex365 ON PerformanceKiller(Col2)
 407 CREATE INDEX idx_StupidIndex366 ON PerformanceKiller(Col2)
 408 CREATE INDEX idx_StupidIndex367 ON PerformanceKiller(Col2)
 409 CREATE INDEX idx_StupidIndex368 ON PerformanceKiller(Col2)
 410 CREATE INDEX idx_StupidIndex369 ON PerformanceKiller(Col2)
 411 CREATE INDEX idx_StupidIndex370 ON PerformanceKiller(Col2)
 412 CREATE INDEX idx_StupidIndex371 ON PerformanceKiller(Col2)
 413 CREATE INDEX idx_StupidIndex372 ON PerformanceKiller(Col2)
 414 CREATE INDEX idx_StupidIndex373 ON PerformanceKiller(Col2)
 415 CREATE INDEX idx_StupidIndex374 ON PerformanceKiller(Col2)
 416 CREATE INDEX idx_StupidIndex375 ON PerformanceKiller(Col2)
 417 CREATE INDEX idx_StupidIndex376 ON PerformanceKiller(Col2)
 418 CREATE INDEX idx_StupidIndex377 ON PerformanceKiller(Col2)
 419 CREATE INDEX idx_StupidIndex378 ON PerformanceKiller(Col2)
 420 CREATE INDEX idx_StupidIndex379 ON PerformanceKiller(Col2)
 421 CREATE INDEX idx_StupidIndex380 ON PerformanceKiller(Col2)
 422 CREATE INDEX idx_StupidIndex381 ON PerformanceKiller(Col2)
 423 CREATE INDEX idx_StupidIndex382 ON PerformanceKiller(Col2)
 424 CREATE INDEX idx_StupidIndex383 ON PerformanceKiller(Col2)
 425 CREATE INDEX idx_StupidIndex384 ON PerformanceKiller(Col2)
 426 CREATE INDEX idx_StupidIndex385 ON PerformanceKiller(Col2)
 427 CREATE INDEX idx_StupidIndex386 ON PerformanceKiller(Col2)
 428 CREATE INDEX idx_StupidIndex387 ON PerformanceKiller(Col2)
 429 CREATE INDEX idx_StupidIndex388 ON PerformanceKiller(Col2)
 430 CREATE INDEX idx_StupidIndex389 ON PerformanceKiller(Col2)
 431 CREATE INDEX idx_StupidIndex390 ON PerformanceKiller(Col2)
 432 CREATE INDEX idx_StupidIndex391 ON PerformanceKiller(Col2)
 433 CREATE INDEX idx_StupidIndex392 ON PerformanceKiller(Col2)
 434 CREATE INDEX idx_StupidIndex393 ON PerformanceKiller(Col2)
 435 CREATE INDEX idx_StupidIndex394 ON PerformanceKiller(Col2)
 436 CREATE INDEX idx_StupidIndex395 ON PerformanceKiller(Col2)
 437 CREATE INDEX idx_StupidIndex396 ON PerformanceKiller(Col2)
 438 CREATE INDEX idx_StupidIndex397 ON PerformanceKiller(Col2)
 439 CREATE INDEX idx_StupidIndex398 ON PerformanceKiller(Col2)
 440 CREATE INDEX idx_StupidIndex399 ON PerformanceKiller(Col2)
 441 CREATE INDEX idx_StupidIndex400 ON PerformanceKiller(Col2)
 442 CREATE INDEX idx_StupidIndex401 ON PerformanceKiller(Col2)
 443 CREATE INDEX idx_StupidIndex402 ON PerformanceKiller(Col2)
 444 CREATE INDEX idx_StupidIndex403 ON PerformanceKiller(Col2)
 445 CREATE INDEX idx_StupidIndex404 ON PerformanceKiller(Col2)
 446 CREATE INDEX idx_StupidIndex405 ON PerformanceKiller(Col2)
 447 CREATE INDEX idx_StupidIndex406 ON PerformanceKiller(Col2)
 448 CREATE INDEX idx_StupidIndex407 ON PerformanceKiller(Col2)
 449 CREATE INDEX idx_StupidIndex408 ON PerformanceKiller(Col2)
 450 CREATE INDEX idx_StupidIndex409 ON PerformanceKiller(Col2)
 451 CREATE INDEX idx_StupidIndex410 ON PerformanceKiller(Col2)
 452 CREATE INDEX idx_StupidIndex411 ON PerformanceKiller(Col2)
 453 CREATE INDEX idx_StupidIndex412 ON PerformanceKiller(Col2)
 454 CREATE INDEX idx_StupidIndex413 ON PerformanceKiller(Col2)
 455 CREATE INDEX idx_StupidIndex414 ON PerformanceKiller(Col2)
 456 CREATE INDEX idx_StupidIndex415 ON PerformanceKiller(Col2)
 457 CREATE INDEX idx_StupidIndex416 ON PerformanceKiller(Col2)
 458 CREATE INDEX idx_StupidIndex417 ON PerformanceKiller(Col2)
 459 CREATE INDEX idx_StupidIndex418 ON PerformanceKiller(Col2)
 460 CREATE INDEX idx_StupidIndex419 ON PerformanceKiller(Col2)
 461 CREATE INDEX idx_StupidIndex420 ON PerformanceKiller(Col2)
 462 CREATE INDEX idx_StupidIndex421 ON PerformanceKiller(Col2)
 463 CREATE INDEX idx_StupidIndex422 ON PerformanceKiller(Col2)
 464 CREATE INDEX idx_StupidIndex423 ON PerformanceKiller(Col2)
 465 CREATE INDEX idx_StupidIndex424 ON PerformanceKiller(Col2)
 466 CREATE INDEX idx_StupidIndex425 ON PerformanceKiller(Col2)
 467 CREATE INDEX idx_StupidIndex426 ON PerformanceKiller(Col2)
 468 CREATE INDEX idx_StupidIndex427 ON PerformanceKiller(Col2)
 469 CREATE INDEX idx_StupidIndex428 ON PerformanceKiller(Col2)
 470 CREATE INDEX idx_StupidIndex429 ON PerformanceKiller(Col2)
 471 CREATE INDEX idx_StupidIndex430 ON PerformanceKiller(Col2)
 472 CREATE INDEX idx_StupidIndex431 ON PerformanceKiller(Col2)
 473 CREATE INDEX idx_StupidIndex432 ON PerformanceKiller(Col2)
 474 CREATE INDEX idx_StupidIndex433 ON PerformanceKiller(Col2)
 475 CREATE INDEX idx_StupidIndex434 ON PerformanceKiller(Col2)
 476 CREATE INDEX idx_StupidIndex435 ON PerformanceKiller(Col2)
 477 CREATE INDEX idx_StupidIndex436 ON PerformanceKiller(Col2)
 478 CREATE INDEX idx_StupidIndex437 ON PerformanceKiller(Col2)
 479 CREATE INDEX idx_StupidIndex438 ON PerformanceKiller(Col2)
 480 CREATE INDEX idx_StupidIndex439 ON PerformanceKiller(Col2)
 481 CREATE INDEX idx_StupidIndex440 ON PerformanceKiller(Col2)
 482 CREATE INDEX idx_StupidIndex441 ON PerformanceKiller(Col2)
 483 CREATE INDEX idx_StupidIndex442 ON PerformanceKiller(Col2)
 484 CREATE INDEX idx_StupidIndex443 ON PerformanceKiller(Col2)
 485 CREATE INDEX idx_StupidIndex444 ON PerformanceKiller(Col2)
 486 CREATE INDEX idx_StupidIndex445 ON PerformanceKiller(Col2)
 487 CREATE INDEX idx_StupidIndex446 ON PerformanceKiller(Col2)
 488 CREATE INDEX idx_StupidIndex447 ON PerformanceKiller(Col2)
 489 CREATE INDEX idx_StupidIndex448 ON PerformanceKiller(Col2)
 490 CREATE INDEX idx_StupidIndex449 ON PerformanceKiller(Col2)
 491 CREATE INDEX idx_StupidIndex450 ON PerformanceKiller(Col2)
 492 CREATE INDEX idx_StupidIndex451 ON PerformanceKiller(Col2)
 493 CREATE INDEX idx_StupidIndex452 ON PerformanceKiller(Col2)
 494 CREATE INDEX idx_StupidIndex453 ON PerformanceKiller(Col2)
 495 CREATE INDEX idx_StupidIndex454 ON PerformanceKiller(Col2)
 496 CREATE INDEX idx_StupidIndex455 ON PerformanceKiller(Col2)
 497 CREATE INDEX idx_StupidIndex456 ON PerformanceKiller(Col2)
 498 CREATE INDEX idx_StupidIndex457 ON PerformanceKiller(Col2)
 499 CREATE INDEX idx_StupidIndex458 ON PerformanceKiller(Col2)
 500 CREATE INDEX idx_StupidIndex459 ON PerformanceKiller(Col2)
 501 CREATE INDEX idx_StupidIndex460 ON PerformanceKiller(Col2)
 502 CREATE INDEX idx_StupidIndex461 ON PerformanceKiller(Col2)
 503 CREATE INDEX idx_StupidIndex462 ON PerformanceKiller(Col2)
 504 CREATE INDEX idx_StupidIndex463 ON PerformanceKiller(Col2)
 505 CREATE INDEX idx_StupidIndex464 ON PerformanceKiller(Col2)
 506 CREATE INDEX idx_StupidIndex465 ON PerformanceKiller(Col2)
 507 CREATE INDEX idx_StupidIndex466 ON PerformanceKiller(Col2)
 508 CREATE INDEX idx_StupidIndex467 ON PerformanceKiller(Col2)
 509 CREATE INDEX idx_StupidIndex468 ON PerformanceKiller(Col2)
 510 CREATE INDEX idx_StupidIndex469 ON PerformanceKiller(Col2)
 511 CREATE INDEX idx_StupidIndex470 ON PerformanceKiller(Col2)
 512 CREATE INDEX idx_StupidIndex471 ON PerformanceKiller(Col2)
 513 CREATE INDEX idx_StupidIndex472 ON PerformanceKiller(Col2)
 514 CREATE INDEX idx_StupidIndex473 ON PerformanceKiller(Col2)
 515 CREATE INDEX idx_StupidIndex474 ON PerformanceKiller(Col2)
 516 CREATE INDEX idx_StupidIndex475 ON PerformanceKiller(Col2)
 517 CREATE INDEX idx_StupidIndex476 ON PerformanceKiller(Col2)
 518 CREATE INDEX idx_StupidIndex477 ON PerformanceKiller(Col2)
 519 CREATE INDEX idx_StupidIndex478 ON PerformanceKiller(Col2)
 520 CREATE INDEX idx_StupidIndex479 ON PerformanceKiller(Col2)
 521 CREATE INDEX idx_StupidIndex480 ON PerformanceKiller(Col2)
 522 CREATE INDEX idx_StupidIndex481 ON PerformanceKiller(Col2)
 523 CREATE INDEX idx_StupidIndex482 ON PerformanceKiller(Col2)
 524 CREATE INDEX idx_StupidIndex483 ON PerformanceKiller(Col2)
 525 CREATE INDEX idx_StupidIndex484 ON PerformanceKiller(Col2)
 526 CREATE INDEX idx_StupidIndex485 ON PerformanceKiller(Col2)
 527 CREATE INDEX idx_StupidIndex486 ON PerformanceKiller(Col2)
 528 CREATE INDEX idx_StupidIndex487 ON PerformanceKiller(Col2)
 529 CREATE INDEX idx_StupidIndex488 ON PerformanceKiller(Col2)
 530 CREATE INDEX idx_StupidIndex489 ON PerformanceKiller(Col2)
 531 CREATE INDEX idx_StupidIndex490 ON PerformanceKiller(Col2)
 532 CREATE INDEX idx_StupidIndex491 ON PerformanceKiller(Col2)
 533 CREATE INDEX idx_StupidIndex492 ON PerformanceKiller(Col2)
 534 CREATE INDEX idx_StupidIndex493 ON PerformanceKiller(Col2)
 535 CREATE INDEX idx_StupidIndex494 ON PerformanceKiller(Col2)
 536 CREATE INDEX idx_StupidIndex495 ON PerformanceKiller(Col2)
 537 CREATE INDEX idx_StupidIndex496 ON PerformanceKiller(Col2)
 538 CREATE INDEX idx_StupidIndex497 ON PerformanceKiller(Col2)
 539 CREATE INDEX idx_StupidIndex498 ON PerformanceKiller(Col2)
 540 CREATE INDEX idx_StupidIndex499 ON PerformanceKiller(Col2)
 541 CREATE INDEX idx_StupidIndex500 ON PerformanceKiller(Col2)
 542 CREATE INDEX idx_StupidIndex501 ON PerformanceKiller(Col2)
 543 CREATE INDEX idx_StupidIndex502 ON PerformanceKiller(Col2)
 544 CREATE INDEX idx_StupidIndex503 ON PerformanceKiller(Col2)
 545 CREATE INDEX idx_StupidIndex504 ON PerformanceKiller(Col2)
 546 CREATE INDEX idx_StupidIndex505 ON PerformanceKiller(Col2)
 547 CREATE INDEX idx_StupidIndex506 ON PerformanceKiller(Col2)
 548 CREATE INDEX idx_StupidIndex507 ON PerformanceKiller(Col2)
 549 CREATE INDEX idx_StupidIndex508 ON PerformanceKiller(Col2)
 550 CREATE INDEX idx_StupidIndex509 ON PerformanceKiller(Col2)
 551 CREATE INDEX idx_StupidIndex510 ON PerformanceKiller(Col2)
 552 CREATE INDEX idx_StupidIndex511 ON PerformanceKiller(Col2)
 553 CREATE INDEX idx_StupidIndex512 ON PerformanceKiller(Col2)
 554 CREATE INDEX idx_StupidIndex513 ON PerformanceKiller(Col2)
 555 CREATE INDEX idx_StupidIndex514 ON PerformanceKiller(Col2)
 556 CREATE INDEX idx_StupidIndex515 ON PerformanceKiller(Col2)
 557 CREATE INDEX idx_StupidIndex516 ON PerformanceKiller(Col2)
 558 CREATE INDEX idx_StupidIndex517 ON PerformanceKiller(Col2)
 559 CREATE INDEX idx_StupidIndex518 ON PerformanceKiller(Col2)
 560 CREATE INDEX idx_StupidIndex519 ON PerformanceKiller(Col2)
 561 CREATE INDEX idx_StupidIndex520 ON PerformanceKiller(Col2)
 562 CREATE INDEX idx_StupidIndex521 ON PerformanceKiller(Col2)
 563 CREATE INDEX idx_StupidIndex522 ON PerformanceKiller(Col2)
 564 CREATE INDEX idx_StupidIndex523 ON PerformanceKiller(Col2)
 565 CREATE INDEX idx_StupidIndex524 ON PerformanceKiller(Col2)
 566 CREATE INDEX idx_StupidIndex525 ON PerformanceKiller(Col2)
 567 CREATE INDEX idx_StupidIndex526 ON PerformanceKiller(Col2)
 568 CREATE INDEX idx_StupidIndex527 ON PerformanceKiller(Col2)
 569 CREATE INDEX idx_StupidIndex528 ON PerformanceKiller(Col2)
 570 CREATE INDEX idx_StupidIndex529 ON PerformanceKiller(Col2)
 571 CREATE INDEX idx_StupidIndex530 ON PerformanceKiller(Col2)
 572 CREATE INDEX idx_StupidIndex531 ON PerformanceKiller(Col2)
 573 CREATE INDEX idx_StupidIndex532 ON PerformanceKiller(Col2)
 574 CREATE INDEX idx_StupidIndex533 ON PerformanceKiller(Col2)
 575 CREATE INDEX idx_StupidIndex534 ON PerformanceKiller(Col2)
 576 CREATE INDEX idx_StupidIndex535 ON PerformanceKiller(Col2)
 577 CREATE INDEX idx_StupidIndex536 ON PerformanceKiller(Col2)
 578 CREATE INDEX idx_StupidIndex537 ON PerformanceKiller(Col2)
 579 CREATE INDEX idx_StupidIndex538 ON PerformanceKiller(Col2)
 580 CREATE INDEX idx_StupidIndex539 ON PerformanceKiller(Col2)
 581 CREATE INDEX idx_StupidIndex540 ON PerformanceKiller(Col2)
 582 CREATE INDEX idx_StupidIndex541 ON PerformanceKiller(Col2)
 583 CREATE INDEX idx_StupidIndex542 ON PerformanceKiller(Col2)
 584 CREATE INDEX idx_StupidIndex543 ON PerformanceKiller(Col2)
 585 CREATE INDEX idx_StupidIndex544 ON PerformanceKiller(Col2)
 586 CREATE INDEX idx_StupidIndex545 ON PerformanceKiller(Col2)
 587 CREATE INDEX idx_StupidIndex546 ON PerformanceKiller(Col2)
 588 CREATE INDEX idx_StupidIndex547 ON PerformanceKiller(Col2)
 589 CREATE INDEX idx_StupidIndex548 ON PerformanceKiller(Col2)
 590 CREATE INDEX idx_StupidIndex549 ON PerformanceKiller(Col2)
 591 CREATE INDEX idx_StupidIndex550 ON PerformanceKiller(Col2)
 592 CREATE INDEX idx_StupidIndex551 ON PerformanceKiller(Col2)
 593 CREATE INDEX idx_StupidIndex552 ON PerformanceKiller(Col2)
 594 CREATE INDEX idx_StupidIndex553 ON PerformanceKiller(Col2)
 595 CREATE INDEX idx_StupidIndex554 ON PerformanceKiller(Col2)
 596 CREATE INDEX idx_StupidIndex555 ON PerformanceKiller(Col2)
 597 CREATE INDEX idx_StupidIndex556 ON PerformanceKiller(Col2)
 598 CREATE INDEX idx_StupidIndex557 ON PerformanceKiller(Col2)
 599 CREATE INDEX idx_StupidIndex558 ON PerformanceKiller(Col2)
 600 CREATE INDEX idx_StupidIndex559 ON PerformanceKiller(Col2)
 601 CREATE INDEX idx_StupidIndex560 ON PerformanceKiller(Col2)
 602 CREATE INDEX idx_StupidIndex561 ON PerformanceKiller(Col2)
 603 CREATE INDEX idx_StupidIndex562 ON PerformanceKiller(Col2)
 604 CREATE INDEX idx_StupidIndex563 ON PerformanceKiller(Col2)
 605 CREATE INDEX idx_StupidIndex564 ON PerformanceKiller(Col2)
 606 CREATE INDEX idx_StupidIndex565 ON PerformanceKiller(Col2)
 607 CREATE INDEX idx_StupidIndex566 ON PerformanceKiller(Col2)
 608 CREATE INDEX idx_StupidIndex567 ON PerformanceKiller(Col2)
 609 CREATE INDEX idx_StupidIndex568 ON PerformanceKiller(Col2)
 610 CREATE INDEX idx_StupidIndex569 ON PerformanceKiller(Col2)
 611 CREATE INDEX idx_StupidIndex570 ON PerformanceKiller(Col2)
 612 CREATE INDEX idx_StupidIndex571 ON PerformanceKiller(Col2)
 613 CREATE INDEX idx_StupidIndex572 ON PerformanceKiller(Col2)
 614 CREATE INDEX idx_StupidIndex573 ON PerformanceKiller(Col2)
 615 CREATE INDEX idx_StupidIndex574 ON PerformanceKiller(Col2)
 616 CREATE INDEX idx_StupidIndex575 ON PerformanceKiller(Col2)
 617 CREATE INDEX idx_StupidIndex576 ON PerformanceKiller(Col2)
 618 CREATE INDEX idx_StupidIndex577 ON PerformanceKiller(Col2)
 619 CREATE INDEX idx_StupidIndex578 ON PerformanceKiller(Col2)
 620 CREATE INDEX idx_StupidIndex579 ON PerformanceKiller(Col2)
 621 CREATE INDEX idx_StupidIndex580 ON PerformanceKiller(Col2)
 622 CREATE INDEX idx_StupidIndex581 ON PerformanceKiller(Col2)
 623 CREATE INDEX idx_StupidIndex582 ON PerformanceKiller(Col2)
 624 CREATE INDEX idx_StupidIndex583 ON PerformanceKiller(Col2)
 625 CREATE INDEX idx_StupidIndex584 ON PerformanceKiller(Col2)
 626 CREATE INDEX idx_StupidIndex585 ON PerformanceKiller(Col2)
 627 CREATE INDEX idx_StupidIndex586 ON PerformanceKiller(Col2)
 628 CREATE INDEX idx_StupidIndex587 ON PerformanceKiller(Col2)
 629 CREATE INDEX idx_StupidIndex588 ON PerformanceKiller(Col2)
 630 CREATE INDEX idx_StupidIndex589 ON PerformanceKiller(Col2)
 631 CREATE INDEX idx_StupidIndex590 ON PerformanceKiller(Col2)
 632 CREATE INDEX idx_StupidIndex591 ON PerformanceKiller(Col2)
 633 CREATE INDEX idx_StupidIndex592 ON PerformanceKiller(Col2)
 634 CREATE INDEX idx_StupidIndex593 ON PerformanceKiller(Col2)
 635 CREATE INDEX idx_StupidIndex594 ON PerformanceKiller(Col2)
 636 CREATE INDEX idx_StupidIndex595 ON PerformanceKiller(Col2)
 637 CREATE INDEX idx_StupidIndex596 ON PerformanceKiller(Col2)
 638 CREATE INDEX idx_StupidIndex597 ON PerformanceKiller(Col2)
 639 CREATE INDEX idx_StupidIndex598 ON PerformanceKiller(Col2)
 640 CREATE INDEX idx_StupidIndex599 ON PerformanceKiller(Col2)
 641 CREATE INDEX idx_StupidIndex600 ON PerformanceKiller(Col2)
 642 CREATE INDEX idx_StupidIndex601 ON PerformanceKiller(Col2)
 643 CREATE INDEX idx_StupidIndex602 ON PerformanceKiller(Col2)
 644 CREATE INDEX idx_StupidIndex603 ON PerformanceKiller(Col2)
 645 CREATE INDEX idx_StupidIndex604 ON PerformanceKiller(Col2)
 646 CREATE INDEX idx_StupidIndex605 ON PerformanceKiller(Col2)
 647 CREATE INDEX idx_StupidIndex606 ON PerformanceKiller(Col2)
 648 CREATE INDEX idx_StupidIndex607 ON PerformanceKiller(Col2)
 649 CREATE INDEX idx_StupidIndex608 ON PerformanceKiller(Col2)
 650 CREATE INDEX idx_StupidIndex609 ON PerformanceKiller(Col2)
 651 CREATE INDEX idx_StupidIndex610 ON PerformanceKiller(Col2)
 652 CREATE INDEX idx_StupidIndex611 ON PerformanceKiller(Col2)
 653 CREATE INDEX idx_StupidIndex612 ON PerformanceKiller(Col2)
 654 CREATE INDEX idx_StupidIndex613 ON PerformanceKiller(Col2)
 655 CREATE INDEX idx_StupidIndex614 ON PerformanceKiller(Col2)
 656 CREATE INDEX idx_StupidIndex615 ON PerformanceKiller(Col2)
 657 CREATE INDEX idx_StupidIndex616 ON PerformanceKiller(Col2)
 658 CREATE INDEX idx_StupidIndex617 ON PerformanceKiller(Col2)
 659 CREATE INDEX idx_StupidIndex618 ON PerformanceKiller(Col2)
 660 CREATE INDEX idx_StupidIndex619 ON PerformanceKiller(Col2)
 661 CREATE INDEX idx_StupidIndex620 ON PerformanceKiller(Col2)
 662 CREATE INDEX idx_StupidIndex621 ON PerformanceKiller(Col2)
 663 CREATE INDEX idx_StupidIndex622 ON PerformanceKiller(Col2)
 664 CREATE INDEX idx_StupidIndex623 ON PerformanceKiller(Col2)
 665 CREATE INDEX idx_StupidIndex624 ON PerformanceKiller(Col2)
 666 CREATE INDEX idx_StupidIndex625 ON PerformanceKiller(Col2)
 667 CREATE INDEX idx_StupidIndex626 ON PerformanceKiller(Col2)
 668 CREATE INDEX idx_StupidIndex627 ON PerformanceKiller(Col2)
 669 CREATE INDEX idx_StupidIndex628 ON PerformanceKiller(Col2)
 670 CREATE INDEX idx_StupidIndex629 ON PerformanceKiller(Col2)
 671 CREATE INDEX idx_StupidIndex630 ON PerformanceKiller(Col2)
 672 CREATE INDEX idx_StupidIndex631 ON PerformanceKiller(Col2)
 673 CREATE INDEX idx_StupidIndex632 ON PerformanceKiller(Col2)
 674 CREATE INDEX idx_StupidIndex633 ON PerformanceKiller(Col2)
 675 CREATE INDEX idx_StupidIndex634 ON PerformanceKiller(Col2)
 676 CREATE INDEX idx_StupidIndex635 ON PerformanceKiller(Col2)
 677 CREATE INDEX idx_StupidIndex636 ON PerformanceKiller(Col2)
 678 CREATE INDEX idx_StupidIndex637 ON PerformanceKiller(Col2)
 679 CREATE INDEX idx_StupidIndex638 ON PerformanceKiller(Col2)
 680 CREATE INDEX idx_StupidIndex639 ON PerformanceKiller(Col2)
 681 CREATE INDEX idx_StupidIndex640 ON PerformanceKiller(Col2)
 682 CREATE INDEX idx_StupidIndex641 ON PerformanceKiller(Col2)
 683 CREATE INDEX idx_StupidIndex642 ON PerformanceKiller(Col2)
 684 CREATE INDEX idx_StupidIndex643 ON PerformanceKiller(Col2)
 685 CREATE INDEX idx_StupidIndex644 ON PerformanceKiller(Col2)
 686 CREATE INDEX idx_StupidIndex645 ON PerformanceKiller(Col2)
 687 CREATE INDEX idx_StupidIndex646 ON PerformanceKiller(Col2)
 688 CREATE INDEX idx_StupidIndex647 ON PerformanceKiller(Col2)
 689 CREATE INDEX idx_StupidIndex648 ON PerformanceKiller(Col2)
 690 CREATE INDEX idx_StupidIndex649 ON PerformanceKiller(Col2)
 691 CREATE INDEX idx_StupidIndex650 ON PerformanceKiller(Col2)
 692 CREATE INDEX idx_StupidIndex651 ON PerformanceKiller(Col2)
 693 CREATE INDEX idx_StupidIndex652 ON PerformanceKiller(Col2)
 694 CREATE INDEX idx_StupidIndex653 ON PerformanceKiller(Col2)
 695 CREATE INDEX idx_StupidIndex654 ON PerformanceKiller(Col2)
 696 CREATE INDEX idx_StupidIndex655 ON PerformanceKiller(Col2)
 697 CREATE INDEX idx_StupidIndex656 ON PerformanceKiller(Col2)
 698 CREATE INDEX idx_StupidIndex657 ON PerformanceKiller(Col2)
 699 CREATE INDEX idx_StupidIndex658 ON PerformanceKiller(Col2)
 700 CREATE INDEX idx_StupidIndex659 ON PerformanceKiller(Col2)
 701 CREATE INDEX idx_StupidIndex660 ON PerformanceKiller(Col2)
 702 CREATE INDEX idx_StupidIndex661 ON PerformanceKiller(Col2)
 703 CREATE INDEX idx_StupidIndex662 ON PerformanceKiller(Col2)
 704 CREATE INDEX idx_StupidIndex663 ON PerformanceKiller(Col2)
 705 CREATE INDEX idx_StupidIndex664 ON PerformanceKiller(Col2)
 706 CREATE INDEX idx_StupidIndex665 ON PerformanceKiller(Col2)
 707 CREATE INDEX idx_StupidIndex666 ON PerformanceKiller(Col2)
 708 CREATE INDEX idx_StupidIndex667 ON PerformanceKiller(Col2)
 709 CREATE INDEX idx_StupidIndex668 ON PerformanceKiller(Col2)
 710 CREATE INDEX idx_StupidIndex669 ON PerformanceKiller(Col2)
 711 CREATE INDEX idx_StupidIndex670 ON PerformanceKiller(Col2)
 712 CREATE INDEX idx_StupidIndex671 ON PerformanceKiller(Col2)
 713 CREATE INDEX idx_StupidIndex672 ON PerformanceKiller(Col2)
 714 CREATE INDEX idx_StupidIndex673 ON PerformanceKiller(Col2)
 715 CREATE INDEX idx_StupidIndex674 ON PerformanceKiller(Col2)
 716 CREATE INDEX idx_StupidIndex675 ON PerformanceKiller(Col2)
 717 CREATE INDEX idx_StupidIndex676 ON PerformanceKiller(Col2)
 718 CREATE INDEX idx_StupidIndex677 ON PerformanceKiller(Col2)
 719 CREATE INDEX idx_StupidIndex678 ON PerformanceKiller(Col2)
 720 CREATE INDEX idx_StupidIndex679 ON PerformanceKiller(Col2)
 721 CREATE INDEX idx_StupidIndex680 ON PerformanceKiller(Col2)
 722 CREATE INDEX idx_StupidIndex681 ON PerformanceKiller(Col2)
 723 CREATE INDEX idx_StupidIndex682 ON PerformanceKiller(Col2)
 724 CREATE INDEX idx_StupidIndex683 ON PerformanceKiller(Col2)
 725 CREATE INDEX idx_StupidIndex684 ON PerformanceKiller(Col2)
 726 CREATE INDEX idx_StupidIndex685 ON PerformanceKiller(Col2)
 727 CREATE INDEX idx_StupidIndex686 ON PerformanceKiller(Col2)
 728 CREATE INDEX idx_StupidIndex687 ON PerformanceKiller(Col2)
 729 CREATE INDEX idx_StupidIndex688 ON PerformanceKiller(Col2)
 730 CREATE INDEX idx_StupidIndex689 ON PerformanceKiller(Col2)
 731 CREATE INDEX idx_StupidIndex690 ON PerformanceKiller(Col2)
 732 CREATE INDEX idx_StupidIndex691 ON PerformanceKiller(Col2)
 733 CREATE INDEX idx_StupidIndex692 ON PerformanceKiller(Col2)
 734 CREATE INDEX idx_StupidIndex693 ON PerformanceKiller(Col2)
 735 CREATE INDEX idx_StupidIndex694 ON PerformanceKiller(Col2)
 736 CREATE INDEX idx_StupidIndex695 ON PerformanceKiller(Col2)
 737 CREATE INDEX idx_StupidIndex696 ON PerformanceKiller(Col2)
 738 CREATE INDEX idx_StupidIndex697 ON PerformanceKiller(Col2)
 739 CREATE INDEX idx_StupidIndex698 ON PerformanceKiller(Col2)
 740 CREATE INDEX idx_StupidIndex699 ON PerformanceKiller(Col2)
 741 CREATE INDEX idx_StupidIndex700 ON PerformanceKiller(Col2)
 742 CREATE INDEX idx_StupidIndex701 ON PerformanceKiller(Col2)
 743 CREATE INDEX idx_StupidIndex702 ON PerformanceKiller(Col2)
 744 CREATE INDEX idx_StupidIndex703 ON PerformanceKiller(Col2)
 745 CREATE INDEX idx_StupidIndex704 ON PerformanceKiller(Col2)
 746 CREATE INDEX idx_StupidIndex705 ON PerformanceKiller(Col2)
 747 CREATE INDEX idx_StupidIndex706 ON PerformanceKiller(Col2)
 748 CREATE INDEX idx_StupidIndex707 ON PerformanceKiller(Col2)
 749 CREATE INDEX idx_StupidIndex708 ON PerformanceKiller(Col2)
 750 CREATE INDEX idx_StupidIndex709 ON PerformanceKiller(Col2)
 751 CREATE INDEX idx_StupidIndex710 ON PerformanceKiller(Col2)
 752 CREATE INDEX idx_StupidIndex711 ON PerformanceKiller(Col2)
 753 CREATE INDEX idx_StupidIndex712 ON PerformanceKiller(Col2)
 754 CREATE INDEX idx_StupidIndex713 ON PerformanceKiller(Col2)
 755 CREATE INDEX idx_StupidIndex714 ON PerformanceKiller(Col2)
 756 CREATE INDEX idx_StupidIndex715 ON PerformanceKiller(Col2)
 757 CREATE INDEX idx_StupidIndex716 ON PerformanceKiller(Col2)
 758 CREATE INDEX idx_StupidIndex717 ON PerformanceKiller(Col2)
 759 CREATE INDEX idx_StupidIndex718 ON PerformanceKiller(Col2)
 760 CREATE INDEX idx_StupidIndex719 ON PerformanceKiller(Col2)
 761 CREATE INDEX idx_StupidIndex720 ON PerformanceKiller(Col2)
 762 CREATE INDEX idx_StupidIndex721 ON PerformanceKiller(Col2)
 763 CREATE INDEX idx_StupidIndex722 ON PerformanceKiller(Col2)
 764 CREATE INDEX idx_StupidIndex723 ON PerformanceKiller(Col2)
 765 CREATE INDEX idx_StupidIndex724 ON PerformanceKiller(Col2)
 766 CREATE INDEX idx_StupidIndex725 ON PerformanceKiller(Col2)
 767 CREATE INDEX idx_StupidIndex726 ON PerformanceKiller(Col2)
 768 CREATE INDEX idx_StupidIndex727 ON PerformanceKiller(Col2)
 769 CREATE INDEX idx_StupidIndex728 ON PerformanceKiller(Col2)
 770 CREATE INDEX idx_StupidIndex729 ON PerformanceKiller(Col2)
 771 CREATE INDEX idx_StupidIndex730 ON PerformanceKiller(Col2)
 772 CREATE INDEX idx_StupidIndex731 ON PerformanceKiller(Col2)
 773 CREATE INDEX idx_StupidIndex732 ON PerformanceKiller(Col2)
 774 CREATE INDEX idx_StupidIndex733 ON PerformanceKiller(Col2)
 775 CREATE INDEX idx_StupidIndex734 ON PerformanceKiller(Col2)
 776 CREATE INDEX idx_StupidIndex735 ON PerformanceKiller(Col2)
 777 CREATE INDEX idx_StupidIndex736 ON PerformanceKiller(Col2)
 778 CREATE INDEX idx_StupidIndex737 ON PerformanceKiller(Col2)
 779 CREATE INDEX idx_StupidIndex738 ON PerformanceKiller(Col2)
 780 CREATE INDEX idx_StupidIndex739 ON PerformanceKiller(Col2)
 781 CREATE INDEX idx_StupidIndex740 ON PerformanceKiller(Col2)
 782 CREATE INDEX idx_StupidIndex741 ON PerformanceKiller(Col2)
 783 CREATE INDEX idx_StupidIndex742 ON PerformanceKiller(Col2)
 784 CREATE INDEX idx_StupidIndex743 ON PerformanceKiller(Col2)
 785 CREATE INDEX idx_StupidIndex744 ON PerformanceKiller(Col2)
 786 CREATE INDEX idx_StupidIndex745 ON PerformanceKiller(Col2)
 787 CREATE INDEX idx_StupidIndex746 ON PerformanceKiller(Col2)
 788 CREATE INDEX idx_StupidIndex747 ON PerformanceKiller(Col2)
 789 CREATE INDEX idx_StupidIndex748 ON PerformanceKiller(Col2)
 790 CREATE INDEX idx_StupidIndex749 ON PerformanceKiller(Col2)
 791 CREATE INDEX idx_StupidIndex750 ON PerformanceKiller(Col2)
 792 CREATE INDEX idx_StupidIndex751 ON PerformanceKiller(Col2)
 793 CREATE INDEX idx_StupidIndex752 ON PerformanceKiller(Col2)
 794 CREATE INDEX idx_StupidIndex753 ON PerformanceKiller(Col2)
 795 CREATE INDEX idx_StupidIndex754 ON PerformanceKiller(Col2)
 796 CREATE INDEX idx_StupidIndex755 ON PerformanceKiller(Col2)
 797 CREATE INDEX idx_StupidIndex756 ON PerformanceKiller(Col2)
 798 CREATE INDEX idx_StupidIndex757 ON PerformanceKiller(Col2)
 799 CREATE INDEX idx_StupidIndex758 ON PerformanceKiller(Col2)
 800 CREATE INDEX idx_StupidIndex759 ON PerformanceKiller(Col2)
 801 CREATE INDEX idx_StupidIndex760 ON PerformanceKiller(Col2)
 802 CREATE INDEX idx_StupidIndex761 ON PerformanceKiller(Col2)
 803 CREATE INDEX idx_StupidIndex762 ON PerformanceKiller(Col2)
 804 CREATE INDEX idx_StupidIndex763 ON PerformanceKiller(Col2)
 805 CREATE INDEX idx_StupidIndex764 ON PerformanceKiller(Col2)
 806 CREATE INDEX idx_StupidIndex765 ON PerformanceKiller(Col2)
 807 CREATE INDEX idx_StupidIndex766 ON PerformanceKiller(Col2)
 808 CREATE INDEX idx_StupidIndex767 ON PerformanceKiller(Col2)
 809 CREATE INDEX idx_StupidIndex768 ON PerformanceKiller(Col2)
 810 CREATE INDEX idx_StupidIndex769 ON PerformanceKiller(Col2)
 811 CREATE INDEX idx_StupidIndex770 ON PerformanceKiller(Col2)
 812 CREATE INDEX idx_StupidIndex771 ON PerformanceKiller(Col2)
 813 CREATE INDEX idx_StupidIndex772 ON PerformanceKiller(Col2)
 814 CREATE INDEX idx_StupidIndex773 ON PerformanceKiller(Col2)
 815 CREATE INDEX idx_StupidIndex774 ON PerformanceKiller(Col2)
 816 CREATE INDEX idx_StupidIndex775 ON PerformanceKiller(Col2)
 817 CREATE INDEX idx_StupidIndex776 ON PerformanceKiller(Col2)
 818 CREATE INDEX idx_StupidIndex777 ON PerformanceKiller(Col2)
 819 CREATE INDEX idx_StupidIndex778 ON PerformanceKiller(Col2)
 820 CREATE INDEX idx_StupidIndex779 ON PerformanceKiller(Col2)
 821 CREATE INDEX idx_StupidIndex780 ON PerformanceKiller(Col2)
 822 CREATE INDEX idx_StupidIndex781 ON PerformanceKiller(Col2)
 823 CREATE INDEX idx_StupidIndex782 ON PerformanceKiller(Col2)
 824 CREATE INDEX idx_StupidIndex783 ON PerformanceKiller(Col2)
 825 CREATE INDEX idx_StupidIndex784 ON PerformanceKiller(Col2)
 826 CREATE INDEX idx_StupidIndex785 ON PerformanceKiller(Col2)
 827 CREATE INDEX idx_StupidIndex786 ON PerformanceKiller(Col2)
 828 CREATE INDEX idx_StupidIndex787 ON PerformanceKiller(Col2)
 829 CREATE INDEX idx_StupidIndex788 ON PerformanceKiller(Col2)
 830 CREATE INDEX idx_StupidIndex789 ON PerformanceKiller(Col2)
 831 CREATE INDEX idx_StupidIndex790 ON PerformanceKiller(Col2)
 832 CREATE INDEX idx_StupidIndex791 ON PerformanceKiller(Col2)
 833 CREATE INDEX idx_StupidIndex792 ON PerformanceKiller(Col2)
 834 CREATE INDEX idx_StupidIndex793 ON PerformanceKiller(Col2)
 835 CREATE INDEX idx_StupidIndex794 ON PerformanceKiller(Col2)
 836 CREATE INDEX idx_StupidIndex795 ON PerformanceKiller(Col2)
 837 CREATE INDEX idx_StupidIndex796 ON PerformanceKiller(Col2)
 838 CREATE INDEX idx_StupidIndex797 ON PerformanceKiller(Col2)
 839 CREATE INDEX idx_StupidIndex798 ON PerformanceKiller(Col2)
 840 CREATE INDEX idx_StupidIndex799 ON PerformanceKiller(Col2)
 841 CREATE INDEX idx_StupidIndex800 ON PerformanceKiller(Col2)
 842 CREATE INDEX idx_StupidIndex801 ON PerformanceKiller(Col2)
 843 CREATE INDEX idx_StupidIndex802 ON PerformanceKiller(Col2)
 844 CREATE INDEX idx_StupidIndex803 ON PerformanceKiller(Col2)
 845 CREATE INDEX idx_StupidIndex804 ON PerformanceKiller(Col2)
 846 CREATE INDEX idx_StupidIndex805 ON PerformanceKiller(Col2)
 847 CREATE INDEX idx_StupidIndex806 ON PerformanceKiller(Col2)
 848 CREATE INDEX idx_StupidIndex807 ON PerformanceKiller(Col2)
 849 CREATE INDEX idx_StupidIndex808 ON PerformanceKiller(Col2)
 850 CREATE INDEX idx_StupidIndex809 ON PerformanceKiller(Col2)
 851 CREATE INDEX idx_StupidIndex810 ON PerformanceKiller(Col2)
 852 CREATE INDEX idx_StupidIndex811 ON PerformanceKiller(Col2)
 853 CREATE INDEX idx_StupidIndex812 ON PerformanceKiller(Col2)
 854 CREATE INDEX idx_StupidIndex813 ON PerformanceKiller(Col2)
 855 CREATE INDEX idx_StupidIndex814 ON PerformanceKiller(Col2)
 856 CREATE INDEX idx_StupidIndex815 ON PerformanceKiller(Col2)
 857 CREATE INDEX idx_StupidIndex816 ON PerformanceKiller(Col2)
 858 CREATE INDEX idx_StupidIndex817 ON PerformanceKiller(Col2)
 859 CREATE INDEX idx_StupidIndex818 ON PerformanceKiller(Col2)
 860 CREATE INDEX idx_StupidIndex819 ON PerformanceKiller(Col2)
 861 CREATE INDEX idx_StupidIndex820 ON PerformanceKiller(Col2)
 862 CREATE INDEX idx_StupidIndex821 ON PerformanceKiller(Col2)
 863 CREATE INDEX idx_StupidIndex822 ON PerformanceKiller(Col2)
 864 CREATE INDEX idx_StupidIndex823 ON PerformanceKiller(Col2)
 865 CREATE INDEX idx_StupidIndex824 ON PerformanceKiller(Col2)
 866 CREATE INDEX idx_StupidIndex825 ON PerformanceKiller(Col2)
 867 CREATE INDEX idx_StupidIndex826 ON PerformanceKiller(Col2)
 868 CREATE INDEX idx_StupidIndex827 ON PerformanceKiller(Col2)
 869 CREATE INDEX idx_StupidIndex828 ON PerformanceKiller(Col2)
 870 CREATE INDEX idx_StupidIndex829 ON PerformanceKiller(Col2)
 871 CREATE INDEX idx_StupidIndex830 ON PerformanceKiller(Col2)
 872 CREATE INDEX idx_StupidIndex831 ON PerformanceKiller(Col2)
 873 CREATE INDEX idx_StupidIndex832 ON PerformanceKiller(Col2)
 874 CREATE INDEX idx_StupidIndex833 ON PerformanceKiller(Col2)
 875 CREATE INDEX idx_StupidIndex834 ON PerformanceKiller(Col2)
 876 CREATE INDEX idx_StupidIndex835 ON PerformanceKiller(Col2)
 877 CREATE INDEX idx_StupidIndex836 ON PerformanceKiller(Col2)
 878 CREATE INDEX idx_StupidIndex837 ON PerformanceKiller(Col2)
 879 CREATE INDEX idx_StupidIndex838 ON PerformanceKiller(Col2)
 880 CREATE INDEX idx_StupidIndex839 ON PerformanceKiller(Col2)
 881 CREATE INDEX idx_StupidIndex840 ON PerformanceKiller(Col2)
 882 CREATE INDEX idx_StupidIndex841 ON PerformanceKiller(Col2)
 883 CREATE INDEX idx_StupidIndex842 ON PerformanceKiller(Col2)
 884 CREATE INDEX idx_StupidIndex843 ON PerformanceKiller(Col2)
 885 CREATE INDEX idx_StupidIndex844 ON PerformanceKiller(Col2)
 886 CREATE INDEX idx_StupidIndex845 ON PerformanceKiller(Col2)
 887 CREATE INDEX idx_StupidIndex846 ON PerformanceKiller(Col2)
 888 CREATE INDEX idx_StupidIndex847 ON PerformanceKiller(Col2)
 889 CREATE INDEX idx_StupidIndex848 ON PerformanceKiller(Col2)
 890 CREATE INDEX idx_StupidIndex849 ON PerformanceKiller(Col2)
 891 CREATE INDEX idx_StupidIndex850 ON PerformanceKiller(Col2)
 892 CREATE INDEX idx_StupidIndex851 ON PerformanceKiller(Col2)
 893 CREATE INDEX idx_StupidIndex852 ON PerformanceKiller(Col2)
 894 CREATE INDEX idx_StupidIndex853 ON PerformanceKiller(Col2)
 895 CREATE INDEX idx_StupidIndex854 ON PerformanceKiller(Col2)
 896 CREATE INDEX idx_StupidIndex855 ON PerformanceKiller(Col2)
 897 CREATE INDEX idx_StupidIndex856 ON PerformanceKiller(Col2)
 898 CREATE INDEX idx_StupidIndex857 ON PerformanceKiller(Col2)
 899 CREATE INDEX idx_StupidIndex858 ON PerformanceKiller(Col2)
 900 CREATE INDEX idx_StupidIndex859 ON PerformanceKiller(Col2)
 901 CREATE INDEX idx_StupidIndex860 ON PerformanceKiller(Col2)
 902 CREATE INDEX idx_StupidIndex861 ON PerformanceKiller(Col2)
 903 CREATE INDEX idx_StupidIndex862 ON PerformanceKiller(Col2)
 904 CREATE INDEX idx_StupidIndex863 ON PerformanceKiller(Col2)
 905 CREATE INDEX idx_StupidIndex864 ON PerformanceKiller(Col2)
 906 CREATE INDEX idx_StupidIndex865 ON PerformanceKiller(Col2)
 907 CREATE INDEX idx_StupidIndex866 ON PerformanceKiller(Col2)
 908 CREATE INDEX idx_StupidIndex867 ON PerformanceKiller(Col2)
 909 CREATE INDEX idx_StupidIndex868 ON PerformanceKiller(Col2)
 910 CREATE INDEX idx_StupidIndex869 ON PerformanceKiller(Col2)
 911 CREATE INDEX idx_StupidIndex870 ON PerformanceKiller(Col2)
 912 CREATE INDEX idx_StupidIndex871 ON PerformanceKiller(Col2)
 913 CREATE INDEX idx_StupidIndex872 ON PerformanceKiller(Col2)
 914 CREATE INDEX idx_StupidIndex873 ON PerformanceKiller(Col2)
 915 CREATE INDEX idx_StupidIndex874 ON PerformanceKiller(Col2)
 916 CREATE INDEX idx_StupidIndex875 ON PerformanceKiller(Col2)
 917 CREATE INDEX idx_StupidIndex876 ON PerformanceKiller(Col2)
 918 CREATE INDEX idx_StupidIndex877 ON PerformanceKiller(Col2)
 919 CREATE INDEX idx_StupidIndex878 ON PerformanceKiller(Col2)
 920 CREATE INDEX idx_StupidIndex879 ON PerformanceKiller(Col2)
 921 CREATE INDEX idx_StupidIndex880 ON PerformanceKiller(Col2)
 922 CREATE INDEX idx_StupidIndex881 ON PerformanceKiller(Col2)
 923 CREATE INDEX idx_StupidIndex882 ON PerformanceKiller(Col2)
 924 CREATE INDEX idx_StupidIndex883 ON PerformanceKiller(Col2)
 925 CREATE INDEX idx_StupidIndex884 ON PerformanceKiller(Col2)
 926 CREATE INDEX idx_StupidIndex885 ON PerformanceKiller(Col2)
 927 CREATE INDEX idx_StupidIndex886 ON PerformanceKiller(Col2)
 928 CREATE INDEX idx_StupidIndex887 ON PerformanceKiller(Col2)
 929 CREATE INDEX idx_StupidIndex888 ON PerformanceKiller(Col2)
 930 CREATE INDEX idx_StupidIndex889 ON PerformanceKiller(Col2)
 931 CREATE INDEX idx_StupidIndex890 ON PerformanceKiller(Col2)
 932 CREATE INDEX idx_StupidIndex891 ON PerformanceKiller(Col2)
 933 CREATE INDEX idx_StupidIndex892 ON PerformanceKiller(Col2)
 934 CREATE INDEX idx_StupidIndex893 ON PerformanceKiller(Col2)
 935 CREATE INDEX idx_StupidIndex894 ON PerformanceKiller(Col2)
 936 CREATE INDEX idx_StupidIndex895 ON PerformanceKiller(Col2)
 937 CREATE INDEX idx_StupidIndex896 ON PerformanceKiller(Col2)
 938 CREATE INDEX idx_StupidIndex897 ON PerformanceKiller(Col2)
 939 CREATE INDEX idx_StupidIndex898 ON PerformanceKiller(Col2)
 940 CREATE INDEX idx_StupidIndex899 ON PerformanceKiller(Col2)
 941 CREATE INDEX idx_StupidIndex900 ON PerformanceKiller(Col2)
 942 CREATE INDEX idx_StupidIndex901 ON PerformanceKiller(Col2)
 943 CREATE INDEX idx_StupidIndex902 ON PerformanceKiller(Col2)
 944 CREATE INDEX idx_StupidIndex903 ON PerformanceKiller(Col2)
 945 CREATE INDEX idx_StupidIndex904 ON PerformanceKiller(Col2)
 946 CREATE INDEX idx_StupidIndex905 ON PerformanceKiller(Col2)
 947 CREATE INDEX idx_StupidIndex906 ON PerformanceKiller(Col2)
 948 CREATE INDEX idx_StupidIndex907 ON PerformanceKiller(Col2)
 949 CREATE INDEX idx_StupidIndex908 ON PerformanceKiller(Col2)
 950 CREATE INDEX idx_StupidIndex909 ON PerformanceKiller(Col2)
 951 CREATE INDEX idx_StupidIndex910 ON PerformanceKiller(Col2)
 952 CREATE INDEX idx_StupidIndex911 ON PerformanceKiller(Col2)
 953 CREATE INDEX idx_StupidIndex912 ON PerformanceKiller(Col2)
 954 CREATE INDEX idx_StupidIndex913 ON PerformanceKiller(Col2)
 955 CREATE INDEX idx_StupidIndex914 ON PerformanceKiller(Col2)
 956 CREATE INDEX idx_StupidIndex915 ON PerformanceKiller(Col2)
 957 CREATE INDEX idx_StupidIndex916 ON PerformanceKiller(Col2)
 958 CREATE INDEX idx_StupidIndex917 ON PerformanceKiller(Col2)
 959 CREATE INDEX idx_StupidIndex918 ON PerformanceKiller(Col2)
 960 CREATE INDEX idx_StupidIndex919 ON PerformanceKiller(Col2)
 961 CREATE INDEX idx_StupidIndex920 ON PerformanceKiller(Col2)
 962 CREATE INDEX idx_StupidIndex921 ON PerformanceKiller(Col2)
 963 CREATE INDEX idx_StupidIndex922 ON PerformanceKiller(Col2)
 964 CREATE INDEX idx_StupidIndex923 ON PerformanceKiller(Col2)
 965 CREATE INDEX idx_StupidIndex924 ON PerformanceKiller(Col2)
 966 CREATE INDEX idx_StupidIndex925 ON PerformanceKiller(Col2)
 967 CREATE INDEX idx_StupidIndex926 ON PerformanceKiller(Col2)
 968 CREATE INDEX idx_StupidIndex927 ON PerformanceKiller(Col2)
 969 CREATE INDEX idx_StupidIndex928 ON PerformanceKiller(Col2)
 970 CREATE INDEX idx_StupidIndex929 ON PerformanceKiller(Col2)
 971 CREATE INDEX idx_StupidIndex930 ON PerformanceKiller(Col2)
 972 CREATE INDEX idx_StupidIndex931 ON PerformanceKiller(Col2)
 973 CREATE INDEX idx_StupidIndex932 ON PerformanceKiller(Col2)
 974 CREATE INDEX idx_StupidIndex933 ON PerformanceKiller(Col2)
 975 CREATE INDEX idx_StupidIndex934 ON PerformanceKiller(Col2)
 976 CREATE INDEX idx_StupidIndex935 ON PerformanceKiller(Col2)
 977 CREATE INDEX idx_StupidIndex936 ON PerformanceKiller(Col2)
 978 CREATE INDEX idx_StupidIndex937 ON PerformanceKiller(Col2)
 979 CREATE INDEX idx_StupidIndex938 ON PerformanceKiller(Col2)
 980 CREATE INDEX idx_StupidIndex939 ON PerformanceKiller(Col2)
 981 CREATE INDEX idx_StupidIndex940 ON PerformanceKiller(Col2)
 982 CREATE INDEX idx_StupidIndex941 ON PerformanceKiller(Col2)
 983 CREATE INDEX idx_StupidIndex942 ON PerformanceKiller(Col2)
 984 CREATE INDEX idx_StupidIndex943 ON PerformanceKiller(Col2)
 985 CREATE INDEX idx_StupidIndex944 ON PerformanceKiller(Col2)
 986 CREATE INDEX idx_StupidIndex945 ON PerformanceKiller(Col2)
 987 CREATE INDEX idx_StupidIndex946 ON PerformanceKiller(Col2)
 988 CREATE INDEX idx_StupidIndex947 ON PerformanceKiller(Col2)
 989 CREATE INDEX idx_StupidIndex948 ON PerformanceKiller(Col2)
 990 CREATE INDEX idx_StupidIndex949 ON PerformanceKiller(Col2)
 991 CREATE INDEX idx_StupidIndex950 ON PerformanceKiller(Col2)
 992 CREATE INDEX idx_StupidIndex951 ON PerformanceKiller(Col2)
 993 CREATE INDEX idx_StupidIndex952 ON PerformanceKiller(Col2)
 994 CREATE INDEX idx_StupidIndex953 ON PerformanceKiller(Col2)
 995 CREATE INDEX idx_StupidIndex954 ON PerformanceKiller(Col2)
 996 CREATE INDEX idx_StupidIndex955 ON PerformanceKiller(Col2)
 997 CREATE INDEX idx_StupidIndex956 ON PerformanceKiller(Col2)
 998 CREATE INDEX idx_StupidIndex957 ON PerformanceKiller(Col2)
 999 CREATE INDEX idx_StupidIndex958 ON PerformanceKiller(Col2)
1000 CREATE INDEX idx_StupidIndex959 ON PerformanceKiller(Col2)
1001 CREATE INDEX idx_StupidIndex960 ON PerformanceKiller(Col2)
1002 CREATE INDEX idx_StupidIndex961 ON PerformanceKiller(Col2)
1003 CREATE INDEX idx_StupidIndex962 ON PerformanceKiller(Col2)
1004 CREATE INDEX idx_StupidIndex963 ON PerformanceKiller(Col2)
1005 CREATE INDEX idx_StupidIndex964 ON PerformanceKiller(Col2)
1006 CREATE INDEX idx_StupidIndex965 ON PerformanceKiller(Col2)
1007 CREATE INDEX idx_StupidIndex966 ON PerformanceKiller(Col2)
1008 CREATE INDEX idx_StupidIndex967 ON PerformanceKiller(Col2)
1009 CREATE INDEX idx_StupidIndex968 ON PerformanceKiller(Col2)
1010 CREATE INDEX idx_StupidIndex969 ON PerformanceKiller(Col2)
1011 CREATE INDEX idx_StupidIndex970 ON PerformanceKiller(Col2)
1012 CREATE INDEX idx_StupidIndex971 ON PerformanceKiller(Col2)
1013 CREATE INDEX idx_StupidIndex972 ON PerformanceKiller(Col2)
1014 CREATE INDEX idx_StupidIndex973 ON PerformanceKiller(Col2)
1015 CREATE INDEX idx_StupidIndex974 ON PerformanceKiller(Col2)
1016 CREATE INDEX idx_StupidIndex975 ON PerformanceKiller(Col2)
1017 CREATE INDEX idx_StupidIndex976 ON PerformanceKiller(Col2)
1018 CREATE INDEX idx_StupidIndex977 ON PerformanceKiller(Col2)
1019 CREATE INDEX idx_StupidIndex978 ON PerformanceKiller(Col2)
1020 CREATE INDEX idx_StupidIndex979 ON PerformanceKiller(Col2)
1021 CREATE INDEX idx_StupidIndex980 ON PerformanceKiller(Col2)
1022 CREATE INDEX idx_StupidIndex981 ON PerformanceKiller(Col2)
1023 CREATE INDEX idx_StupidIndex982 ON PerformanceKiller(Col2)
1024 CREATE INDEX idx_StupidIndex983 ON PerformanceKiller(Col2)
1025 CREATE INDEX idx_StupidIndex984 ON PerformanceKiller(Col2)
1026 CREATE INDEX idx_StupidIndex985 ON PerformanceKiller(Col2)
1027 CREATE INDEX idx_StupidIndex986 ON PerformanceKiller(Col2)
1028 CREATE INDEX idx_StupidIndex987 ON PerformanceKiller(Col2)
1029 CREATE INDEX idx_StupidIndex988 ON PerformanceKiller(Col2)
1030 CREATE INDEX idx_StupidIndex989 ON PerformanceKiller(Col2)
1031 CREATE INDEX idx_StupidIndex990 ON PerformanceKiller(Col2)
1032 CREATE INDEX idx_StupidIndex991 ON PerformanceKiller(Col2)
1033 CREATE INDEX idx_StupidIndex992 ON PerformanceKiller(Col2)
1034 CREATE INDEX idx_StupidIndex993 ON PerformanceKiller(Col2)
1035 CREATE INDEX idx_StupidIndex994 ON PerformanceKiller(Col2)
1036 CREATE INDEX idx_StupidIndex995 ON PerformanceKiller(Col2)
1037 CREATE INDEX idx_StupidIndex996 ON PerformanceKiller(Col2)
1038 CREATE INDEX idx_StupidIndex997 ON PerformanceKiller(Col2)
1039 CREATE INDEX idx_StupidIndex998 ON PerformanceKiller(Col2)
1040 CREATE INDEX idx_StupidIndex999 ON PerformanceKiller(Col2)
1041 GO

View Code

SQL Server的这个行为也很疯狂：它从不抱怨你是否在重复创建“一样”的非聚集索引。你只需要确保选择的索引名称是唯一的……

在SQL Server里对于表，999也是非聚集索引的最大数量。如果你尝试创建一个更多的的非聚集索引，SQL Server会返回一个错误信息：

1 -- More than 999 Non-Clustered Indexes are not supported...
2 CREATE INDEX idx_StupidIndex1000 ON PerformanceKiller(Col2)
3 GO

当你现在查询表的的sys.indexes时，你会看到1000条记录：1条聚集索引，999条非聚集索引……

1 -- Yes, we are really crazy
2 SELECT * FROM sys.indexes
3 WHERE object_id = OBJECT_ID('PerformanceKiller')
4 GO

在表创建完后，我就插入了100000条记录到表。现在我们对表执行一些特定的SQL语句来修改数据。首先，我们用简单的UPDATE语句更新50条记录

1 -- Let's perform a "simple" UPDATE statement against 50 rows...
2 BEGIN TRANSACTION
3 
4 UPDATE PerformanceKiller
5 SET Col2 = Col2 + 1
6 WHERE Col2 BETWEEN 100 AND 150
7 
8 ROLLBACK
9 GO

这个语句执行起来真的很慢！我在的系统里花了近5秒钟！想象下！200毫秒来修改50条记录。但事实上，你不止修改了50条记录：对于每个修改行，你要修改聚集索引/非聚集索引里对应的索引记录！在这个表上，我们定义了1000个索引，因此我们要进行50000个索引更新！（1000 x 50）。而且那个SQL语句生成超过200000个逻辑读！现在我们不提交的事务里，执行100行记录的DELETE语句：

 1 -- Let's perform a "simple" DELETE statement against 100 rows...
 2 BEGIN TRANSACTION
 3 
 4 DELETE FROM PerformanceKiller
 5 WHERE Col2 BETWEEN 200 AND 300
 6 
 7 SELECT
 8     database_transaction_log_record_count,
 9     database_transaction_log_bytes_used
10 FROM sys.dm_tran_database_transactions
11 WHERE database_id = DB_ID('TooMuchIndexes')
12 
13 ROLLBACK
14 GO

同样，你会进行10000个索引删除（1000 x 10）。SQL Server需要在事务日志里记录一切。如果你查询下sys.dm_tran_database_transactions这个DMV，你会看到，在事务日志里，当前的操作需要近10M的空间。这里你创建了巨大的开销。

现在假设你回滚这个事务。在我的系统里这个事务的回滚花了近500毫秒！因此会花费更多的时间让数据库回到一致状态。

小结

对于包含999个非聚集索引的表，不管你做什么：一切都很慢！正如我刚开始就说过的：对于你的工作量，你应该创建尽可能少的非聚集索引。你有越少的索引，写操作的负担就越轻！

感谢关注！

原文链接：

https://www.sqlpassion.at/archive/2016/06/20/999-non-clustered-indexes-on-a-table-a-good-idea/

posted @ 2016-06-21 16:18 Woodytu 阅读(1500) 评论(3) 编辑收藏举报

会员力量，点亮园子希望

刷新页面返回顶部

Woodytu

MS SQL Passion. Live like How SQL Server thinks.

表上999个非聚集索引——你怎么看？

我们来创建一个可怕的表！

小结

原文链接：

公告