你的位置:首页 > 数据库

[数据库]表上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 crazy2 SELECT * FROM sys.indexes3 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 TRANSACTION3 4 UPDATE PerformanceKiller5 SET Col2 = Col2 + 16 WHERE Col2 BETWEEN 100 AND 1507 8 ROLLBACK9 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_used10 FROM sys.dm_tran_database_transactions11 WHERE database_id = DB_ID('TooMuchIndexes')12 13 ROLLBACK14 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/