SQLsever2008群数据建立索引与查询

最新推荐文章于 2022-08-24 15:45:51 发布

kb623456

最新推荐文章于 2022-08-24 15:45:51 发布

阅读量1.2k

点赞数

分类专栏：数据库文章标签： SQL 数据库索引源码优化

数据库专栏收录该内容

1 篇文章 0 订阅

订阅专栏

建立索引部分（出处：http://www.rover12421.com/2013/12/01/qq-leaked-database-query-optimization.html）我只选了一部分，时间大概几小时吧

---------------------------------------------
--QQ数据库查询优化
--By Rover12421
--执行完改SQL脚本,可以通过proc_findQunUseQQNum查询
--exec proc_findQunUseQQNum 12345678
--执行效率在15-20s左右
--如有更好的优化希望能告知
--Email:rover12421@163.com
----------------------------------------------
--给GroupData中的表创建QQNum的索引
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group7') 
 CREATE INDEX ix_QQNum_Group7 On GroupData1.dbo.Group7 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group75') 
 CREATE INDEX ix_QQNum_Group75 On GroupData1.dbo.Group75 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group8') 
 CREATE INDEX ix_QQNum_Group8 On GroupData1.dbo.Group8 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group76') 
 CREATE INDEX ix_QQNum_Group76 On GroupData1.dbo.Group76 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group9') 
 CREATE INDEX ix_QQNum_Group9 On GroupData1.dbo.Group9 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group77') 
 CREATE INDEX ix_QQNum_Group77 On GroupData1.dbo.Group77 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group10') 
 CREATE INDEX ix_QQNum_Group10 On GroupData1.dbo.Group10 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group78') 
 CREATE INDEX ix_QQNum_Group78 On GroupData1.dbo.Group78 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group11') 
 CREATE INDEX ix_QQNum_Group11 On GroupData1.dbo.Group11 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group79') 
 CREATE INDEX ix_QQNum_Group79 On GroupData1.dbo.Group79 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group12') 
 CREATE INDEX ix_QQNum_Group12 On GroupData1.dbo.Group12 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group80') 
 CREATE INDEX ix_QQNum_Group80 On GroupData1.dbo.Group80 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group13') 
 CREATE INDEX ix_QQNum_Group13 On GroupData1.dbo.Group13 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group81') 
 CREATE INDEX ix_QQNum_Group81 On GroupData1.dbo.Group81 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group14') 
 CREATE INDEX ix_QQNum_Group14 On GroupData1.dbo.Group14 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group82') 
 CREATE INDEX ix_QQNum_Group82 On GroupData1.dbo.Group82 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group15') 
 CREATE INDEX ix_QQNum_Group15 On GroupData1.dbo.Group15 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group83') 
 CREATE INDEX ix_QQNum_Group83 On GroupData1.dbo.Group83 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group16') 
 CREATE INDEX ix_QQNum_Group16 On GroupData1.dbo.Group16 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group84') 
 CREATE INDEX ix_QQNum_Group84 On GroupData1.dbo.Group84 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group17') 
 CREATE INDEX ix_QQNum_Group17 On GroupData1.dbo.Group17 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group85') 
 CREATE INDEX ix_QQNum_Group85 On GroupData1.dbo.Group85 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group18') 
 CREATE INDEX ix_QQNum_Group18 On GroupData1.dbo.Group18 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group86') 
 CREATE INDEX ix_QQNum_Group86 On GroupData1.dbo.Group86 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group19') 
 CREATE INDEX ix_QQNum_Group19 On GroupData1.dbo.Group19 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group87') 
 CREATE INDEX ix_QQNum_Group87 On GroupData1.dbo.Group87 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group20') 
 CREATE INDEX ix_QQNum_Group20 On GroupData1.dbo.Group20 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group88') 
 CREATE INDEX ix_QQNum_Group88 On GroupData1.dbo.Group88 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group21') 
 CREATE INDEX ix_QQNum_Group21 On GroupData1.dbo.Group21 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group89') 
 CREATE INDEX ix_QQNum_Group89 On GroupData1.dbo.Group89 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group22') 
 CREATE INDEX ix_QQNum_Group22 On GroupData1.dbo.Group22 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group90') 
 CREATE INDEX ix_QQNum_Group90 On GroupData1.dbo.Group90 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group23') 
 CREATE INDEX ix_QQNum_Group23 On GroupData1.dbo.Group23 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group91') 
 CREATE INDEX ix_QQNum_Group91 On GroupData1.dbo.Group91 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group24') 
 CREATE INDEX ix_QQNum_Group24 On GroupData1.dbo.Group24 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group92') 
 CREATE INDEX ix_QQNum_Group92 On GroupData1.dbo.Group92 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group25') 
 CREATE INDEX ix_QQNum_Group25 On GroupData1.dbo.Group25 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group93') 
 CREATE INDEX ix_QQNum_Group93 On GroupData1.dbo.Group93 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group26') 
 CREATE INDEX ix_QQNum_Group26 On GroupData1.dbo.Group26 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group94') 
 CREATE INDEX ix_QQNum_Group94 On GroupData1.dbo.Group94 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group27') 
 CREATE INDEX ix_QQNum_Group27 On GroupData1.dbo.Group27 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group95') 
 CREATE INDEX ix_QQNum_Group95 On GroupData1.dbo.Group95 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group28') 
 CREATE INDEX ix_QQNum_Group28 On GroupData1.dbo.Group28 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group96') 
 CREATE INDEX ix_QQNum_Group96 On GroupData1.dbo.Group96 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group29') 
 CREATE INDEX ix_QQNum_Group29 On GroupData1.dbo.Group29 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group97') 
 CREATE INDEX ix_QQNum_Group97 On GroupData1.dbo.Group97 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group30') 
 CREATE INDEX ix_QQNum_Group30 On GroupData1.dbo.Group30 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group98') 
 CREATE INDEX ix_QQNum_Group98 On GroupData1.dbo.Group98 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group31') 
 CREATE INDEX ix_QQNum_Group31 On GroupData1.dbo.Group31 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group99') 
 CREATE INDEX ix_QQNum_Group99 On GroupData1.dbo.Group99 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group32') 
 CREATE INDEX ix_QQNum_Group32 On GroupData1.dbo.Group32 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group100') 
 CREATE INDEX ix_QQNum_Group100 On GroupData1.dbo.Group100 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group33') 
 CREATE INDEX ix_QQNum_Group33 On GroupData1.dbo.Group33 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group34') 
 CREATE INDEX ix_QQNum_Group34 On GroupData1.dbo.Group34 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group35') 
 CREATE INDEX ix_QQNum_Group35 On GroupData1.dbo.Group35 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group36') 
 CREATE INDEX ix_QQNum_Group36 On GroupData1.dbo.Group36 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group37') 
 CREATE INDEX ix_QQNum_Group37 On GroupData1.dbo.Group37 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group38') 
 CREATE INDEX ix_QQNum_Group38 On GroupData1.dbo.Group38 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group39') 
 CREATE INDEX ix_QQNum_Group39 On GroupData1.dbo.Group39 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group40') 
 CREATE INDEX ix_QQNum_Group40 On GroupData1.dbo.Group40 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group41') 
 CREATE INDEX ix_QQNum_Group41 On GroupData1.dbo.Group41 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group42') 
 CREATE INDEX ix_QQNum_Group42 On GroupData1.dbo.Group42 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group43') 
 CREATE INDEX ix_QQNum_Group43 On GroupData1.dbo.Group43 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group44') 
 CREATE INDEX ix_QQNum_Group44 On GroupData1.dbo.Group44 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group45') 
 CREATE INDEX ix_QQNum_Group45 On GroupData1.dbo.Group45 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group46') 
 CREATE INDEX ix_QQNum_Group46 On GroupData1.dbo.Group46 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group47') 
 CREATE INDEX ix_QQNum_Group47 On GroupData1.dbo.Group47 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group48') 
 CREATE INDEX ix_QQNum_Group48 On GroupData1.dbo.Group48 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group49') 
 CREATE INDEX ix_QQNum_Group49 On GroupData1.dbo.Group49 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group50') 
 CREATE INDEX ix_QQNum_Group50 On GroupData1.dbo.Group50 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group51') 
 CREATE INDEX ix_QQNum_Group51 On GroupData1.dbo.Group51 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group52') 
 CREATE INDEX ix_QQNum_Group52 On GroupData1.dbo.Group52 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group53') 
 CREATE INDEX ix_QQNum_Group53 On GroupData1.dbo.Group53 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group54') 
 CREATE INDEX ix_QQNum_Group54 On GroupData1.dbo.Group54 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group55') 
 CREATE INDEX ix_QQNum_Group55 On GroupData1.dbo.Group55 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group56') 
 CREATE INDEX ix_QQNum_Group56 On GroupData1.dbo.Group56 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group57') 
 CREATE INDEX ix_QQNum_Group57 On GroupData1.dbo.Group57 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group58') 
 CREATE INDEX ix_QQNum_Group58 On GroupData1.dbo.Group58 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group59') 
 CREATE INDEX ix_QQNum_Group59 On GroupData1.dbo.Group59 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group60') 
 CREATE INDEX ix_QQNum_Group60 On GroupData1.dbo.Group60 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group61') 
 CREATE INDEX ix_QQNum_Group61 On GroupData1.dbo.Group61 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group62') 
 CREATE INDEX ix_QQNum_Group62 On GroupData1.dbo.Group62 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group63') 
 CREATE INDEX ix_QQNum_Group63 On GroupData1.dbo.Group63 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group64') 
 CREATE INDEX ix_QQNum_Group64 On GroupData1.dbo.Group64 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group65') 
 CREATE INDEX ix_QQNum_Group65 On GroupData1.dbo.Group65 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group66') 
 CREATE INDEX ix_QQNum_Group66 On GroupData1.dbo.Group66 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group67') 
 CREATE INDEX ix_QQNum_Group67 On GroupData1.dbo.Group67 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group68') 
 CREATE INDEX ix_QQNum_Group68 On GroupData1.dbo.Group68 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group1') 
 CREATE INDEX ix_QQNum_Group1 On GroupData1.dbo.Group1 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group69') 
 CREATE INDEX ix_QQNum_Group69 On GroupData1.dbo.Group69 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group2') 
 CREATE INDEX ix_QQNum_Group2 On GroupData1.dbo.Group2 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group70') 
 CREATE INDEX ix_QQNum_Group70 On GroupData1.dbo.Group70 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group3') 
 CREATE INDEX ix_QQNum_Group3 On GroupData1.dbo.Group3 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group71') 
 CREATE INDEX ix_QQNum_Group71 On GroupData1.dbo.Group71 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group4') 
 CREATE INDEX ix_QQNum_Group4 On GroupData1.dbo.Group4 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group72') 
 CREATE INDEX ix_QQNum_Group72 On GroupData1.dbo.Group72 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group5') 
 CREATE INDEX ix_QQNum_Group5 On GroupData1.dbo.Group5 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group73') 
 CREATE INDEX ix_QQNum_Group73 On GroupData1.dbo.Group73 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData1.dbo.sysindexes WHERE name = 'ix_QQNum_Group6') 
 CREATE INDEX ix_QQNum_Group6 On GroupData1.dbo.Group6 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group174') 
 CREATE INDEX ix_QQNum_Group174 On GroupData2.dbo.Group174 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group107') 
 CREATE INDEX ix_QQNum_Group107 On GroupData2.dbo.Group107 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group175') 
 CREATE INDEX ix_QQNum_Group175 On GroupData2.dbo.Group175 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group108') 
 CREATE INDEX ix_QQNum_Group108 On GroupData2.dbo.Group108 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group176') 
 CREATE INDEX ix_QQNum_Group176 On GroupData2.dbo.Group176 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group109') 
 CREATE INDEX ix_QQNum_Group109 On GroupData2.dbo.Group109 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group177') 
 CREATE INDEX ix_QQNum_Group177 On GroupData2.dbo.Group177 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group110') 
 CREATE INDEX ix_QQNum_Group110 On GroupData2.dbo.Group110 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group178') 
 CREATE INDEX ix_QQNum_Group178 On GroupData2.dbo.Group178 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group111') 
 CREATE INDEX ix_QQNum_Group111 On GroupData2.dbo.Group111 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group179') 
 CREATE INDEX ix_QQNum_Group179 On GroupData2.dbo.Group179 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group112') 
 CREATE INDEX ix_QQNum_Group112 On GroupData2.dbo.Group112 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group180') 
 CREATE INDEX ix_QQNum_Group180 On GroupData2.dbo.Group180 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group113') 
 CREATE INDEX ix_QQNum_Group113 On GroupData2.dbo.Group113 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group181') 
 CREATE INDEX ix_QQNum_Group181 On GroupData2.dbo.Group181 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group114') 
 CREATE INDEX ix_QQNum_Group114 On GroupData2.dbo.Group114 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group182') 
 CREATE INDEX ix_QQNum_Group182 On GroupData2.dbo.Group182 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group115') 
 CREATE INDEX ix_QQNum_Group115 On GroupData2.dbo.Group115 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group183') 
 CREATE INDEX ix_QQNum_Group183 On GroupData2.dbo.Group183 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group116') 
 CREATE INDEX ix_QQNum_Group116 On GroupData2.dbo.Group116 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group184') 
 CREATE INDEX ix_QQNum_Group184 On GroupData2.dbo.Group184 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group117') 
 CREATE INDEX ix_QQNum_Group117 On GroupData2.dbo.Group117 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group185') 
 CREATE INDEX ix_QQNum_Group185 On GroupData2.dbo.Group185 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group118') 
 CREATE INDEX ix_QQNum_Group118 On GroupData2.dbo.Group118 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group186') 
 CREATE INDEX ix_QQNum_Group186 On GroupData2.dbo.Group186 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group119') 
 CREATE INDEX ix_QQNum_Group119 On GroupData2.dbo.Group119 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group187') 
 CREATE INDEX ix_QQNum_Group187 On GroupData2.dbo.Group187 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group120') 
 CREATE INDEX ix_QQNum_Group120 On GroupData2.dbo.Group120 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group188') 
 CREATE INDEX ix_QQNum_Group188 On GroupData2.dbo.Group188 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group121') 
 CREATE INDEX ix_QQNum_Group121 On GroupData2.dbo.Group121 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group189') 
 CREATE INDEX ix_QQNum_Group189 On GroupData2.dbo.Group189 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group122') 
 CREATE INDEX ix_QQNum_Group122 On GroupData2.dbo.Group122 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group190') 
 CREATE INDEX ix_QQNum_Group190 On GroupData2.dbo.Group190 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group123') 
 CREATE INDEX ix_QQNum_Group123 On GroupData2.dbo.Group123 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group191') 
 CREATE INDEX ix_QQNum_Group191 On GroupData2.dbo.Group191 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group124') 
 CREATE INDEX ix_QQNum_Group124 On GroupData2.dbo.Group124 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group192') 
 CREATE INDEX ix_QQNum_Group192 On GroupData2.dbo.Group192 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group125') 
 CREATE INDEX ix_QQNum_Group125 On GroupData2.dbo.Group125 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group193') 
 CREATE INDEX ix_QQNum_Group193 On GroupData2.dbo.Group193 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group126') 
 CREATE INDEX ix_QQNum_Group126 On GroupData2.dbo.Group126 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group194') 
 CREATE INDEX ix_QQNum_Group194 On GroupData2.dbo.Group194 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group127') 
 CREATE INDEX ix_QQNum_Group127 On GroupData2.dbo.Group127 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group195') 
 CREATE INDEX ix_QQNum_Group195 On GroupData2.dbo.Group195 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group128') 
 CREATE INDEX ix_QQNum_Group128 On GroupData2.dbo.Group128 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group196') 
 CREATE INDEX ix_QQNum_Group196 On GroupData2.dbo.Group196 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group129') 
 CREATE INDEX ix_QQNum_Group129 On GroupData2.dbo.Group129 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group197') 
 CREATE INDEX ix_QQNum_Group197 On GroupData2.dbo.Group197 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group130') 
 CREATE INDEX ix_QQNum_Group130 On GroupData2.dbo.Group130 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group198') 
 CREATE INDEX ix_QQNum_Group198 On GroupData2.dbo.Group198 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group131') 
 CREATE INDEX ix_QQNum_Group131 On GroupData2.dbo.Group131 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group199') 
 CREATE INDEX ix_QQNum_Group199 On GroupData2.dbo.Group199 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group132') 
 CREATE INDEX ix_QQNum_Group132 On GroupData2.dbo.Group132 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group200') 
 CREATE INDEX ix_QQNum_Group200 On GroupData2.dbo.Group200 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group133') 
 CREATE INDEX ix_QQNum_Group133 On GroupData2.dbo.Group133 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group134') 
 CREATE INDEX ix_QQNum_Group134 On GroupData2.dbo.Group134 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group135') 
 CREATE INDEX ix_QQNum_Group135 On GroupData2.dbo.Group135 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group136') 
 CREATE INDEX ix_QQNum_Group136 On GroupData2.dbo.Group136 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group137') 
 CREATE INDEX ix_QQNum_Group137 On GroupData2.dbo.Group137 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group138') 
 CREATE INDEX ix_QQNum_Group138 On GroupData2.dbo.Group138 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group139') 
 CREATE INDEX ix_QQNum_Group139 On GroupData2.dbo.Group139 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group140') 
 CREATE INDEX ix_QQNum_Group140 On GroupData2.dbo.Group140 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group141') 
 CREATE INDEX ix_QQNum_Group141 On GroupData2.dbo.Group141 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group142') 
 CREATE INDEX ix_QQNum_Group142 On GroupData2.dbo.Group142 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group143') 
 CREATE INDEX ix_QQNum_Group143 On GroupData2.dbo.Group143 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group144') 
 CREATE INDEX ix_QQNum_Group144 On GroupData2.dbo.Group144 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group145') 
 CREATE INDEX ix_QQNum_Group145 On GroupData2.dbo.Group145 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group146') 
 CREATE INDEX ix_QQNum_Group146 On GroupData2.dbo.Group146 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group147') 
 CREATE INDEX ix_QQNum_Group147 On GroupData2.dbo.Group147 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group148') 
 CREATE INDEX ix_QQNum_Group148 On GroupData2.dbo.Group148 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group149') 
 CREATE INDEX ix_QQNum_Group149 On GroupData2.dbo.Group149 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group150') 
 CREATE INDEX ix_QQNum_Group150 On GroupData2.dbo.Group150 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group151') 
 CREATE INDEX ix_QQNum_Group151 On GroupData2.dbo.Group151 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group152') 
 CREATE INDEX ix_QQNum_Group152 On GroupData2.dbo.Group152 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group153') 
 CREATE INDEX ix_QQNum_Group153 On GroupData2.dbo.Group153 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group154') 
 CREATE INDEX ix_QQNum_Group154 On GroupData2.dbo.Group154 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group155') 
 CREATE INDEX ix_QQNum_Group155 On GroupData2.dbo.Group155 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group156') 
 CREATE INDEX ix_QQNum_Group156 On GroupData2.dbo.Group156 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group157') 
 CREATE INDEX ix_QQNum_Group157 On GroupData2.dbo.Group157 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group158') 
 CREATE INDEX ix_QQNum_Group158 On GroupData2.dbo.Group158 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group159') 
 CREATE INDEX ix_QQNum_Group159 On GroupData2.dbo.Group159 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group160') 
 CREATE INDEX ix_QQNum_Group160 On GroupData2.dbo.Group160 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group161') 
 CREATE INDEX ix_QQNum_Group161 On GroupData2.dbo.Group161 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group162') 
 CREATE INDEX ix_QQNum_Group162 On GroupData2.dbo.Group162 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group163') 
 CREATE INDEX ix_QQNum_Group163 On GroupData2.dbo.Group163 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group164') 
 CREATE INDEX ix_QQNum_Group164 On GroupData2.dbo.Group164 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group165') 
 CREATE INDEX ix_QQNum_Group165 On GroupData2.dbo.Group165 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group166') 
 CREATE INDEX ix_QQNum_Group166 On GroupData2.dbo.Group166 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group167') 
 CREATE INDEX ix_QQNum_Group167 On GroupData2.dbo.Group167 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group168') 
 CREATE INDEX ix_QQNum_Group168 On GroupData2.dbo.Group168 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group101') 
 CREATE INDEX ix_QQNum_Group101 On GroupData2.dbo.Group101 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group169') 
 CREATE INDEX ix_QQNum_Group169 On GroupData2.dbo.Group169 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group102') 
 CREATE INDEX ix_QQNum_Group102 On GroupData2.dbo.Group102 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group170') 
 CREATE INDEX ix_QQNum_Group170 On GroupData2.dbo.Group170 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group103') 
 CREATE INDEX ix_QQNum_Group103 On GroupData2.dbo.Group103 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group171') 
 CREATE INDEX ix_QQNum_Group171 On GroupData2.dbo.Group171 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group104') 
 CREATE INDEX ix_QQNum_Group104 On GroupData2.dbo.Group104 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group172') 
 CREATE INDEX ix_QQNum_Group172 On GroupData2.dbo.Group172 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group105') 
 CREATE INDEX ix_QQNum_Group105 On GroupData2.dbo.Group105 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group173') 
 CREATE INDEX ix_QQNum_Group173 On GroupData2.dbo.Group173 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData2.dbo.sysindexes WHERE name = 'ix_QQNum_Group106') 
 CREATE INDEX ix_QQNum_Group106 On GroupData2.dbo.Group106 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group274') 
 CREATE INDEX ix_QQNum_Group274 On GroupData3.dbo.Group274 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group207') 
 CREATE INDEX ix_QQNum_Group207 On GroupData3.dbo.Group207 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group275') 
 CREATE INDEX ix_QQNum_Group275 On GroupData3.dbo.Group275 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group208') 
 CREATE INDEX ix_QQNum_Group208 On GroupData3.dbo.Group208 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group276') 
 CREATE INDEX ix_QQNum_Group276 On GroupData3.dbo.Group276 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group209') 
 CREATE INDEX ix_QQNum_Group209 On GroupData3.dbo.Group209 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group277') 
 CREATE INDEX ix_QQNum_Group277 On GroupData3.dbo.Group277 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group210') 
 CREATE INDEX ix_QQNum_Group210 On GroupData3.dbo.Group210 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group278') 
 CREATE INDEX ix_QQNum_Group278 On GroupData3.dbo.Group278 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group211') 
 CREATE INDEX ix_QQNum_Group211 On GroupData3.dbo.Group211 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group279') 
 CREATE INDEX ix_QQNum_Group279 On GroupData3.dbo.Group279 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group212') 
 CREATE INDEX ix_QQNum_Group212 On GroupData3.dbo.Group212 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group280') 
 CREATE INDEX ix_QQNum_Group280 On GroupData3.dbo.Group280 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group213') 
 CREATE INDEX ix_QQNum_Group213 On GroupData3.dbo.Group213 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group281') 
 CREATE INDEX ix_QQNum_Group281 On GroupData3.dbo.Group281 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group214') 
 CREATE INDEX ix_QQNum_Group214 On GroupData3.dbo.Group214 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group282') 
 CREATE INDEX ix_QQNum_Group282 On GroupData3.dbo.Group282 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group215') 
 CREATE INDEX ix_QQNum_Group215 On GroupData3.dbo.Group215 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group283') 
 CREATE INDEX ix_QQNum_Group283 On GroupData3.dbo.Group283 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group216') 
 CREATE INDEX ix_QQNum_Group216 On GroupData3.dbo.Group216 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group284') 
 CREATE INDEX ix_QQNum_Group284 On GroupData3.dbo.Group284 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group217') 
 CREATE INDEX ix_QQNum_Group217 On GroupData3.dbo.Group217 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group285') 
 CREATE INDEX ix_QQNum_Group285 On GroupData3.dbo.Group285 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group218') 
 CREATE INDEX ix_QQNum_Group218 On GroupData3.dbo.Group218 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group286') 
 CREATE INDEX ix_QQNum_Group286 On GroupData3.dbo.Group286 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group219') 
 CREATE INDEX ix_QQNum_Group219 On GroupData3.dbo.Group219 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group287') 
 CREATE INDEX ix_QQNum_Group287 On GroupData3.dbo.Group287 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group220') 
 CREATE INDEX ix_QQNum_Group220 On GroupData3.dbo.Group220 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group288') 
 CREATE INDEX ix_QQNum_Group288 On GroupData3.dbo.Group288 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group221') 
 CREATE INDEX ix_QQNum_Group221 On GroupData3.dbo.Group221 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group289') 
 CREATE INDEX ix_QQNum_Group289 On GroupData3.dbo.Group289 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group222') 
 CREATE INDEX ix_QQNum_Group222 On GroupData3.dbo.Group222 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group290') 
 CREATE INDEX ix_QQNum_Group290 On GroupData3.dbo.Group290 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group223') 
 CREATE INDEX ix_QQNum_Group223 On GroupData3.dbo.Group223 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group291') 
 CREATE INDEX ix_QQNum_Group291 On GroupData3.dbo.Group291 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group224') 
 CREATE INDEX ix_QQNum_Group224 On GroupData3.dbo.Group224 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group292') 
 CREATE INDEX ix_QQNum_Group292 On GroupData3.dbo.Group292 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group225') 
 CREATE INDEX ix_QQNum_Group225 On GroupData3.dbo.Group225 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group293') 
 CREATE INDEX ix_QQNum_Group293 On GroupData3.dbo.Group293 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group226') 
 CREATE INDEX ix_QQNum_Group226 On GroupData3.dbo.Group226 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group294') 
 CREATE INDEX ix_QQNum_Group294 On GroupData3.dbo.Group294 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group227') 
 CREATE INDEX ix_QQNum_Group227 On GroupData3.dbo.Group227 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group295') 
 CREATE INDEX ix_QQNum_Group295 On GroupData3.dbo.Group295 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group228') 
 CREATE INDEX ix_QQNum_Group228 On GroupData3.dbo.Group228 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group296') 
 CREATE INDEX ix_QQNum_Group296 On GroupData3.dbo.Group296 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group229') 
 CREATE INDEX ix_QQNum_Group229 On GroupData3.dbo.Group229 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group297') 
 CREATE INDEX ix_QQNum_Group297 On GroupData3.dbo.Group297 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group230') 
 CREATE INDEX ix_QQNum_Group230 On GroupData3.dbo.Group230 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group298') 
 CREATE INDEX ix_QQNum_Group298 On GroupData3.dbo.Group298 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group231') 
 CREATE INDEX ix_QQNum_Group231 On GroupData3.dbo.Group231 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group299') 
 CREATE INDEX ix_QQNum_Group299 On GroupData3.dbo.Group299 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group232') 
 CREATE INDEX ix_QQNum_Group232 On GroupData3.dbo.Group232 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group300') 
 CREATE INDEX ix_QQNum_Group300 On GroupData3.dbo.Group300 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group233') 
 CREATE INDEX ix_QQNum_Group233 On GroupData3.dbo.Group233 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group234') 
 CREATE INDEX ix_QQNum_Group234 On GroupData3.dbo.Group234 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group235') 
 CREATE INDEX ix_QQNum_Group235 On GroupData3.dbo.Group235 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group236') 
 CREATE INDEX ix_QQNum_Group236 On GroupData3.dbo.Group236 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group237') 
 CREATE INDEX ix_QQNum_Group237 On GroupData3.dbo.Group237 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group238') 
 CREATE INDEX ix_QQNum_Group238 On GroupData3.dbo.Group238 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group239') 
 CREATE INDEX ix_QQNum_Group239 On GroupData3.dbo.Group239 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group240') 
 CREATE INDEX ix_QQNum_Group240 On GroupData3.dbo.Group240 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group241') 
 CREATE INDEX ix_QQNum_Group241 On GroupData3.dbo.Group241 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group242') 
 CREATE INDEX ix_QQNum_Group242 On GroupData3.dbo.Group242 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group243') 
 CREATE INDEX ix_QQNum_Group243 On GroupData3.dbo.Group243 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group244') 
 CREATE INDEX ix_QQNum_Group244 On GroupData3.dbo.Group244 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group245') 
 CREATE INDEX ix_QQNum_Group245 On GroupData3.dbo.Group245 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group246') 
 CREATE INDEX ix_QQNum_Group246 On GroupData3.dbo.Group246 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group247') 
 CREATE INDEX ix_QQNum_Group247 On GroupData3.dbo.Group247 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group248') 
 CREATE INDEX ix_QQNum_Group248 On GroupData3.dbo.Group248 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group249') 
 CREATE INDEX ix_QQNum_Group249 On GroupData3.dbo.Group249 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group250') 
 CREATE INDEX ix_QQNum_Group250 On GroupData3.dbo.Group250 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group251') 
 CREATE INDEX ix_QQNum_Group251 On GroupData3.dbo.Group251 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group252') 
 CREATE INDEX ix_QQNum_Group252 On GroupData3.dbo.Group252 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group253') 
 CREATE INDEX ix_QQNum_Group253 On GroupData3.dbo.Group253 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group254') 
 CREATE INDEX ix_QQNum_Group254 On GroupData3.dbo.Group254 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group255') 
 CREATE INDEX ix_QQNum_Group255 On GroupData3.dbo.Group255 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group256') 
 CREATE INDEX ix_QQNum_Group256 On GroupData3.dbo.Group256 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group257') 
 CREATE INDEX ix_QQNum_Group257 On GroupData3.dbo.Group257 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group258') 
 CREATE INDEX ix_QQNum_Group258 On GroupData3.dbo.Group258 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group259') 
 CREATE INDEX ix_QQNum_Group259 On GroupData3.dbo.Group259 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group260') 
 CREATE INDEX ix_QQNum_Group260 On GroupData3.dbo.Group260 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group261') 
 CREATE INDEX ix_QQNum_Group261 On GroupData3.dbo.Group261 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group262') 
 CREATE INDEX ix_QQNum_Group262 On GroupData3.dbo.Group262 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group263') 
 CREATE INDEX ix_QQNum_Group263 On GroupData3.dbo.Group263 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group264') 
 CREATE INDEX ix_QQNum_Group264 On GroupData3.dbo.Group264 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group265') 
 CREATE INDEX ix_QQNum_Group265 On GroupData3.dbo.Group265 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group266') 
 CREATE INDEX ix_QQNum_Group266 On GroupData3.dbo.Group266 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group267') 
 CREATE INDEX ix_QQNum_Group267 On GroupData3.dbo.Group267 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group268') 
 CREATE INDEX ix_QQNum_Group268 On GroupData3.dbo.Group268 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group201') 
 CREATE INDEX ix_QQNum_Group201 On GroupData3.dbo.Group201 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group269') 
 CREATE INDEX ix_QQNum_Group269 On GroupData3.dbo.Group269 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group202') 
 CREATE INDEX ix_QQNum_Group202 On GroupData3.dbo.Group202 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group270') 
 CREATE INDEX ix_QQNum_Group270 On GroupData3.dbo.Group270 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group203') 
 CREATE INDEX ix_QQNum_Group203 On GroupData3.dbo.Group203 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group271') 
 CREATE INDEX ix_QQNum_Group271 On GroupData3.dbo.Group271 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group204') 
 CREATE INDEX ix_QQNum_Group204 On GroupData3.dbo.Group204 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group272') 
 CREATE INDEX ix_QQNum_Group272 On GroupData3.dbo.Group272 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group205') 
 CREATE INDEX ix_QQNum_Group205 On GroupData3.dbo.Group205 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group273') 
 CREATE INDEX ix_QQNum_Group273 On GroupData3.dbo.Group273 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData3.dbo.sysindexes WHERE name = 'ix_QQNum_Group206') 
 CREATE INDEX ix_QQNum_Group206 On GroupData3.dbo.Group206 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group374') 
 CREATE INDEX ix_QQNum_Group374 On GroupData4.dbo.Group374 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group307') 
 CREATE INDEX ix_QQNum_Group307 On GroupData4.dbo.Group307 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group375') 
 CREATE INDEX ix_QQNum_Group375 On GroupData4.dbo.Group375 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group308') 
 CREATE INDEX ix_QQNum_Group308 On GroupData4.dbo.Group308 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group376') 
 CREATE INDEX ix_QQNum_Group376 On GroupData4.dbo.Group376 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group309') 
 CREATE INDEX ix_QQNum_Group309 On GroupData4.dbo.Group309 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group377') 
 CREATE INDEX ix_QQNum_Group377 On GroupData4.dbo.Group377 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group310') 
 CREATE INDEX ix_QQNum_Group310 On GroupData4.dbo.Group310 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group378') 
 CREATE INDEX ix_QQNum_Group378 On GroupData4.dbo.Group378 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group311') 
 CREATE INDEX ix_QQNum_Group311 On GroupData4.dbo.Group311 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group379') 
 CREATE INDEX ix_QQNum_Group379 On GroupData4.dbo.Group379 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group312') 
 CREATE INDEX ix_QQNum_Group312 On GroupData4.dbo.Group312 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group380') 
 CREATE INDEX ix_QQNum_Group380 On GroupData4.dbo.Group380 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group313') 
 CREATE INDEX ix_QQNum_Group313 On GroupData4.dbo.Group313 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group381') 
 CREATE INDEX ix_QQNum_Group381 On GroupData4.dbo.Group381 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group314') 
 CREATE INDEX ix_QQNum_Group314 On GroupData4.dbo.Group314 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group382') 
 CREATE INDEX ix_QQNum_Group382 On GroupData4.dbo.Group382 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group315') 
 CREATE INDEX ix_QQNum_Group315 On GroupData4.dbo.Group315 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group383') 
 CREATE INDEX ix_QQNum_Group383 On GroupData4.dbo.Group383 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group316') 
 CREATE INDEX ix_QQNum_Group316 On GroupData4.dbo.Group316 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group384') 
 CREATE INDEX ix_QQNum_Group384 On GroupData4.dbo.Group384 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group317') 
 CREATE INDEX ix_QQNum_Group317 On GroupData4.dbo.Group317 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group385') 
 CREATE INDEX ix_QQNum_Group385 On GroupData4.dbo.Group385 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group318') 
 CREATE INDEX ix_QQNum_Group318 On GroupData4.dbo.Group318 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group386') 
 CREATE INDEX ix_QQNum_Group386 On GroupData4.dbo.Group386 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group319') 
 CREATE INDEX ix_QQNum_Group319 On GroupData4.dbo.Group319 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group387') 
 CREATE INDEX ix_QQNum_Group387 On GroupData4.dbo.Group387 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group320') 
 CREATE INDEX ix_QQNum_Group320 On GroupData4.dbo.Group320 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group388') 
 CREATE INDEX ix_QQNum_Group388 On GroupData4.dbo.Group388 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group321') 
 CREATE INDEX ix_QQNum_Group321 On GroupData4.dbo.Group321 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group389') 
 CREATE INDEX ix_QQNum_Group389 On GroupData4.dbo.Group389 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group322') 
 CREATE INDEX ix_QQNum_Group322 On GroupData4.dbo.Group322 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group390') 
 CREATE INDEX ix_QQNum_Group390 On GroupData4.dbo.Group390 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group323') 
 CREATE INDEX ix_QQNum_Group323 On GroupData4.dbo.Group323 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group391') 
 CREATE INDEX ix_QQNum_Group391 On GroupData4.dbo.Group391 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group324') 
 CREATE INDEX ix_QQNum_Group324 On GroupData4.dbo.Group324 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group392') 
 CREATE INDEX ix_QQNum_Group392 On GroupData4.dbo.Group392 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group325') 
 CREATE INDEX ix_QQNum_Group325 On GroupData4.dbo.Group325 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group393') 
 CREATE INDEX ix_QQNum_Group393 On GroupData4.dbo.Group393 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group326') 
 CREATE INDEX ix_QQNum_Group326 On GroupData4.dbo.Group326 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group394') 
 CREATE INDEX ix_QQNum_Group394 On GroupData4.dbo.Group394 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group327') 
 CREATE INDEX ix_QQNum_Group327 On GroupData4.dbo.Group327 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group395') 
 CREATE INDEX ix_QQNum_Group395 On GroupData4.dbo.Group395 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group328') 
 CREATE INDEX ix_QQNum_Group328 On GroupData4.dbo.Group328 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group396') 
 CREATE INDEX ix_QQNum_Group396 On GroupData4.dbo.Group396 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group329') 
 CREATE INDEX ix_QQNum_Group329 On GroupData4.dbo.Group329 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group397') 
 CREATE INDEX ix_QQNum_Group397 On GroupData4.dbo.Group397 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group330') 
 CREATE INDEX ix_QQNum_Group330 On GroupData4.dbo.Group330 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group398') 
 CREATE INDEX ix_QQNum_Group398 On GroupData4.dbo.Group398 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group331') 
 CREATE INDEX ix_QQNum_Group331 On GroupData4.dbo.Group331 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group399') 
 CREATE INDEX ix_QQNum_Group399 On GroupData4.dbo.Group399 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group332') 
 CREATE INDEX ix_QQNum_Group332 On GroupData4.dbo.Group332 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group400') 
 CREATE INDEX ix_QQNum_Group400 On GroupData4.dbo.Group400 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group333') 
 CREATE INDEX ix_QQNum_Group333 On GroupData4.dbo.Group333 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group334') 
 CREATE INDEX ix_QQNum_Group334 On GroupData4.dbo.Group334 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group335') 
 CREATE INDEX ix_QQNum_Group335 On GroupData4.dbo.Group335 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group336') 
 CREATE INDEX ix_QQNum_Group336 On GroupData4.dbo.Group336 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group337') 
 CREATE INDEX ix_QQNum_Group337 On GroupData4.dbo.Group337 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group338') 
 CREATE INDEX ix_QQNum_Group338 On GroupData4.dbo.Group338 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group339') 
 CREATE INDEX ix_QQNum_Group339 On GroupData4.dbo.Group339 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group340') 
 CREATE INDEX ix_QQNum_Group340 On GroupData4.dbo.Group340 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group341') 
 CREATE INDEX ix_QQNum_Group341 On GroupData4.dbo.Group341 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group342') 
 CREATE INDEX ix_QQNum_Group342 On GroupData4.dbo.Group342 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group343') 
 CREATE INDEX ix_QQNum_Group343 On GroupData4.dbo.Group343 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group344') 
 CREATE INDEX ix_QQNum_Group344 On GroupData4.dbo.Group344 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group345') 
 CREATE INDEX ix_QQNum_Group345 On GroupData4.dbo.Group345 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group346') 
 CREATE INDEX ix_QQNum_Group346 On GroupData4.dbo.Group346 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group347') 
 CREATE INDEX ix_QQNum_Group347 On GroupData4.dbo.Group347 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group348') 
 CREATE INDEX ix_QQNum_Group348 On GroupData4.dbo.Group348 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group349') 
 CREATE INDEX ix_QQNum_Group349 On GroupData4.dbo.Group349 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group350') 
 CREATE INDEX ix_QQNum_Group350 On GroupData4.dbo.Group350 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group351') 
 CREATE INDEX ix_QQNum_Group351 On GroupData4.dbo.Group351 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group352') 
 CREATE INDEX ix_QQNum_Group352 On GroupData4.dbo.Group352 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group353') 
 CREATE INDEX ix_QQNum_Group353 On GroupData4.dbo.Group353 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group354') 
 CREATE INDEX ix_QQNum_Group354 On GroupData4.dbo.Group354 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group355') 
 CREATE INDEX ix_QQNum_Group355 On GroupData4.dbo.Group355 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group356') 
 CREATE INDEX ix_QQNum_Group356 On GroupData4.dbo.Group356 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group357') 
 CREATE INDEX ix_QQNum_Group357 On GroupData4.dbo.Group357 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group358') 
 CREATE INDEX ix_QQNum_Group358 On GroupData4.dbo.Group358 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group359') 
 CREATE INDEX ix_QQNum_Group359 On GroupData4.dbo.Group359 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group360') 
 CREATE INDEX ix_QQNum_Group360 On GroupData4.dbo.Group360 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group361') 
 CREATE INDEX ix_QQNum_Group361 On GroupData4.dbo.Group361 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group362') 
 CREATE INDEX ix_QQNum_Group362 On GroupData4.dbo.Group362 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group363') 
 CREATE INDEX ix_QQNum_Group363 On GroupData4.dbo.Group363 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group364') 
 CREATE INDEX ix_QQNum_Group364 On GroupData4.dbo.Group364 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group365') 
 CREATE INDEX ix_QQNum_Group365 On GroupData4.dbo.Group365 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group366') 
 CREATE INDEX ix_QQNum_Group366 On GroupData4.dbo.Group366 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group367') 
 CREATE INDEX ix_QQNum_Group367 On GroupData4.dbo.Group367 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group368') 
 CREATE INDEX ix_QQNum_Group368 On GroupData4.dbo.Group368 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group301') 
 CREATE INDEX ix_QQNum_Group301 On GroupData4.dbo.Group301 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group369') 
 CREATE INDEX ix_QQNum_Group369 On GroupData4.dbo.Group369 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group302') 
 CREATE INDEX ix_QQNum_Group302 On GroupData4.dbo.Group302 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group370') 
 CREATE INDEX ix_QQNum_Group370 On GroupData4.dbo.Group370 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group303') 
 CREATE INDEX ix_QQNum_Group303 On GroupData4.dbo.Group303 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group371') 
 CREATE INDEX ix_QQNum_Group371 On GroupData4.dbo.Group371 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group304') 
 CREATE INDEX ix_QQNum_Group304 On GroupData4.dbo.Group304 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group372') 
 CREATE INDEX ix_QQNum_Group372 On GroupData4.dbo.Group372 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group305') 
 CREATE INDEX ix_QQNum_Group305 On GroupData4.dbo.Group305 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group373') 
 CREATE INDEX ix_QQNum_Group373 On GroupData4.dbo.Group373 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData4.dbo.sysindexes WHERE name = 'ix_QQNum_Group306') 
 CREATE INDEX ix_QQNum_Group306 On GroupData4.dbo.Group306 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group474') 
 CREATE INDEX ix_QQNum_Group474 On GroupData5.dbo.Group474 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group407') 
 CREATE INDEX ix_QQNum_Group407 On GroupData5.dbo.Group407 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group475') 
 CREATE INDEX ix_QQNum_Group475 On GroupData5.dbo.Group475 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group408') 
 CREATE INDEX ix_QQNum_Group408 On GroupData5.dbo.Group408 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group476') 
 CREATE INDEX ix_QQNum_Group476 On GroupData5.dbo.Group476 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group409') 
 CREATE INDEX ix_QQNum_Group409 On GroupData5.dbo.Group409 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group477') 
 CREATE INDEX ix_QQNum_Group477 On GroupData5.dbo.Group477 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group410') 
 CREATE INDEX ix_QQNum_Group410 On GroupData5.dbo.Group410 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group478') 
 CREATE INDEX ix_QQNum_Group478 On GroupData5.dbo.Group478 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group411') 
 CREATE INDEX ix_QQNum_Group411 On GroupData5.dbo.Group411 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group479') 
 CREATE INDEX ix_QQNum_Group479 On GroupData5.dbo.Group479 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group412') 
 CREATE INDEX ix_QQNum_Group412 On GroupData5.dbo.Group412 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group480') 
 CREATE INDEX ix_QQNum_Group480 On GroupData5.dbo.Group480 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group413') 
 CREATE INDEX ix_QQNum_Group413 On GroupData5.dbo.Group413 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group481') 
 CREATE INDEX ix_QQNum_Group481 On GroupData5.dbo.Group481 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group414') 
 CREATE INDEX ix_QQNum_Group414 On GroupData5.dbo.Group414 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group482') 
 CREATE INDEX ix_QQNum_Group482 On GroupData5.dbo.Group482 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group415') 
 CREATE INDEX ix_QQNum_Group415 On GroupData5.dbo.Group415 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group483') 
 CREATE INDEX ix_QQNum_Group483 On GroupData5.dbo.Group483 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group416') 
 CREATE INDEX ix_QQNum_Group416 On GroupData5.dbo.Group416 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group484') 
 CREATE INDEX ix_QQNum_Group484 On GroupData5.dbo.Group484 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group417') 
 CREATE INDEX ix_QQNum_Group417 On GroupData5.dbo.Group417 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group485') 
 CREATE INDEX ix_QQNum_Group485 On GroupData5.dbo.Group485 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group418') 
 CREATE INDEX ix_QQNum_Group418 On GroupData5.dbo.Group418 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group486') 
 CREATE INDEX ix_QQNum_Group486 On GroupData5.dbo.Group486 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group419') 
 CREATE INDEX ix_QQNum_Group419 On GroupData5.dbo.Group419 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group487') 
 CREATE INDEX ix_QQNum_Group487 On GroupData5.dbo.Group487 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group420') 
 CREATE INDEX ix_QQNum_Group420 On GroupData5.dbo.Group420 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group488') 
 CREATE INDEX ix_QQNum_Group488 On GroupData5.dbo.Group488 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group421') 
 CREATE INDEX ix_QQNum_Group421 On GroupData5.dbo.Group421 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group489') 
 CREATE INDEX ix_QQNum_Group489 On GroupData5.dbo.Group489 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group422') 
 CREATE INDEX ix_QQNum_Group422 On GroupData5.dbo.Group422 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group490') 
 CREATE INDEX ix_QQNum_Group490 On GroupData5.dbo.Group490 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group423') 
 CREATE INDEX ix_QQNum_Group423 On GroupData5.dbo.Group423 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group491') 
 CREATE INDEX ix_QQNum_Group491 On GroupData5.dbo.Group491 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group424') 
 CREATE INDEX ix_QQNum_Group424 On GroupData5.dbo.Group424 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group492') 
 CREATE INDEX ix_QQNum_Group492 On GroupData5.dbo.Group492 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group425') 
 CREATE INDEX ix_QQNum_Group425 On GroupData5.dbo.Group425 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group493') 
 CREATE INDEX ix_QQNum_Group493 On GroupData5.dbo.Group493 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group426') 
 CREATE INDEX ix_QQNum_Group426 On GroupData5.dbo.Group426 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group494') 
 CREATE INDEX ix_QQNum_Group494 On GroupData5.dbo.Group494 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group427') 
 CREATE INDEX ix_QQNum_Group427 On GroupData5.dbo.Group427 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group495') 
 CREATE INDEX ix_QQNum_Group495 On GroupData5.dbo.Group495 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group428') 
 CREATE INDEX ix_QQNum_Group428 On GroupData5.dbo.Group428 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group496') 
 CREATE INDEX ix_QQNum_Group496 On GroupData5.dbo.Group496 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group429') 
 CREATE INDEX ix_QQNum_Group429 On GroupData5.dbo.Group429 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group497') 
 CREATE INDEX ix_QQNum_Group497 On GroupData5.dbo.Group497 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group430') 
 CREATE INDEX ix_QQNum_Group430 On GroupData5.dbo.Group430 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group498') 
 CREATE INDEX ix_QQNum_Group498 On GroupData5.dbo.Group498 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group431') 
 CREATE INDEX ix_QQNum_Group431 On GroupData5.dbo.Group431 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group499') 
 CREATE INDEX ix_QQNum_Group499 On GroupData5.dbo.Group499 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group432') 
 CREATE INDEX ix_QQNum_Group432 On GroupData5.dbo.Group432 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group500') 
 CREATE INDEX ix_QQNum_Group500 On GroupData5.dbo.Group500 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group433') 
 CREATE INDEX ix_QQNum_Group433 On GroupData5.dbo.Group433 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group434') 
 CREATE INDEX ix_QQNum_Group434 On GroupData5.dbo.Group434 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group435') 
 CREATE INDEX ix_QQNum_Group435 On GroupData5.dbo.Group435 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group436') 
 CREATE INDEX ix_QQNum_Group436 On GroupData5.dbo.Group436 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group437') 
 CREATE INDEX ix_QQNum_Group437 On GroupData5.dbo.Group437 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group438') 
 CREATE INDEX ix_QQNum_Group438 On GroupData5.dbo.Group438 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group439') 
 CREATE INDEX ix_QQNum_Group439 On GroupData5.dbo.Group439 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group440') 
 CREATE INDEX ix_QQNum_Group440 On GroupData5.dbo.Group440 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group441') 
 CREATE INDEX ix_QQNum_Group441 On GroupData5.dbo.Group441 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group442') 
 CREATE INDEX ix_QQNum_Group442 On GroupData5.dbo.Group442 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group443') 
 CREATE INDEX ix_QQNum_Group443 On GroupData5.dbo.Group443 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group444') 
 CREATE INDEX ix_QQNum_Group444 On GroupData5.dbo.Group444 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group445') 
 CREATE INDEX ix_QQNum_Group445 On GroupData5.dbo.Group445 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group446') 
 CREATE INDEX ix_QQNum_Group446 On GroupData5.dbo.Group446 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group447') 
 CREATE INDEX ix_QQNum_Group447 On GroupData5.dbo.Group447 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group448') 
 CREATE INDEX ix_QQNum_Group448 On GroupData5.dbo.Group448 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group449') 
 CREATE INDEX ix_QQNum_Group449 On GroupData5.dbo.Group449 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group450') 
 CREATE INDEX ix_QQNum_Group450 On GroupData5.dbo.Group450 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group451') 
 CREATE INDEX ix_QQNum_Group451 On GroupData5.dbo.Group451 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group452') 
 CREATE INDEX ix_QQNum_Group452 On GroupData5.dbo.Group452 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group453') 
 CREATE INDEX ix_QQNum_Group453 On GroupData5.dbo.Group453 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group454') 
 CREATE INDEX ix_QQNum_Group454 On GroupData5.dbo.Group454 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group455') 
 CREATE INDEX ix_QQNum_Group455 On GroupData5.dbo.Group455 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group456') 
 CREATE INDEX ix_QQNum_Group456 On GroupData5.dbo.Group456 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group457') 
 CREATE INDEX ix_QQNum_Group457 On GroupData5.dbo.Group457 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group458') 
 CREATE INDEX ix_QQNum_Group458 On GroupData5.dbo.Group458 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group459') 
 CREATE INDEX ix_QQNum_Group459 On GroupData5.dbo.Group459 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group460') 
 CREATE INDEX ix_QQNum_Group460 On GroupData5.dbo.Group460 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group461') 
 CREATE INDEX ix_QQNum_Group461 On GroupData5.dbo.Group461 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group462') 
 CREATE INDEX ix_QQNum_Group462 On GroupData5.dbo.Group462 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group463') 
 CREATE INDEX ix_QQNum_Group463 On GroupData5.dbo.Group463 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group464') 
 CREATE INDEX ix_QQNum_Group464 On GroupData5.dbo.Group464 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group465') 
 CREATE INDEX ix_QQNum_Group465 On GroupData5.dbo.Group465 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group466') 
 CREATE INDEX ix_QQNum_Group466 On GroupData5.dbo.Group466 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group467') 
 CREATE INDEX ix_QQNum_Group467 On GroupData5.dbo.Group467 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group468') 
 CREATE INDEX ix_QQNum_Group468 On GroupData5.dbo.Group468 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group401') 
 CREATE INDEX ix_QQNum_Group401 On GroupData5.dbo.Group401 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group469') 
 CREATE INDEX ix_QQNum_Group469 On GroupData5.dbo.Group469 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group402') 
 CREATE INDEX ix_QQNum_Group402 On GroupData5.dbo.Group402 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group470') 
 CREATE INDEX ix_QQNum_Group470 On GroupData5.dbo.Group470 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group403') 
 CREATE INDEX ix_QQNum_Group403 On GroupData5.dbo.Group403 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group471') 
 CREATE INDEX ix_QQNum_Group471 On GroupData5.dbo.Group471 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group404') 
 CREATE INDEX ix_QQNum_Group404 On GroupData5.dbo.Group404 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group472') 
 CREATE INDEX ix_QQNum_Group472 On GroupData5.dbo.Group472 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group405') 
 CREATE INDEX ix_QQNum_Group405 On GroupData5.dbo.Group405 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group473') 
 CREATE INDEX ix_QQNum_Group473 On GroupData5.dbo.Group473 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData5.dbo.sysindexes WHERE name = 'ix_QQNum_Group406') 
 CREATE INDEX ix_QQNum_Group406 On GroupData5.dbo.Group406 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group574') 
 CREATE INDEX ix_QQNum_Group574 On GroupData6.dbo.Group574 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group507') 
 CREATE INDEX ix_QQNum_Group507 On GroupData6.dbo.Group507 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group575') 
 CREATE INDEX ix_QQNum_Group575 On GroupData6.dbo.Group575 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group508') 
 CREATE INDEX ix_QQNum_Group508 On GroupData6.dbo.Group508 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group576') 
 CREATE INDEX ix_QQNum_Group576 On GroupData6.dbo.Group576 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group509') 
 CREATE INDEX ix_QQNum_Group509 On GroupData6.dbo.Group509 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group577') 
 CREATE INDEX ix_QQNum_Group577 On GroupData6.dbo.Group577 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group510') 
 CREATE INDEX ix_QQNum_Group510 On GroupData6.dbo.Group510 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group578') 
 CREATE INDEX ix_QQNum_Group578 On GroupData6.dbo.Group578 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group511') 
 CREATE INDEX ix_QQNum_Group511 On GroupData6.dbo.Group511 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group579') 
 CREATE INDEX ix_QQNum_Group579 On GroupData6.dbo.Group579 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group512') 
 CREATE INDEX ix_QQNum_Group512 On GroupData6.dbo.Group512 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group580') 
 CREATE INDEX ix_QQNum_Group580 On GroupData6.dbo.Group580 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group513') 
 CREATE INDEX ix_QQNum_Group513 On GroupData6.dbo.Group513 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group581') 
 CREATE INDEX ix_QQNum_Group581 On GroupData6.dbo.Group581 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group514') 
 CREATE INDEX ix_QQNum_Group514 On GroupData6.dbo.Group514 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group582') 
 CREATE INDEX ix_QQNum_Group582 On GroupData6.dbo.Group582 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group515') 
 CREATE INDEX ix_QQNum_Group515 On GroupData6.dbo.Group515 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group583') 
 CREATE INDEX ix_QQNum_Group583 On GroupData6.dbo.Group583 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group516') 
 CREATE INDEX ix_QQNum_Group516 On GroupData6.dbo.Group516 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group584') 
 CREATE INDEX ix_QQNum_Group584 On GroupData6.dbo.Group584 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group517') 
 CREATE INDEX ix_QQNum_Group517 On GroupData6.dbo.Group517 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group585') 
 CREATE INDEX ix_QQNum_Group585 On GroupData6.dbo.Group585 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group518') 
 CREATE INDEX ix_QQNum_Group518 On GroupData6.dbo.Group518 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group586') 
 CREATE INDEX ix_QQNum_Group586 On GroupData6.dbo.Group586 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group519') 
 CREATE INDEX ix_QQNum_Group519 On GroupData6.dbo.Group519 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group587') 
 CREATE INDEX ix_QQNum_Group587 On GroupData6.dbo.Group587 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group520') 
 CREATE INDEX ix_QQNum_Group520 On GroupData6.dbo.Group520 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group588') 
 CREATE INDEX ix_QQNum_Group588 On GroupData6.dbo.Group588 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group521') 
 CREATE INDEX ix_QQNum_Group521 On GroupData6.dbo.Group521 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group589') 
 CREATE INDEX ix_QQNum_Group589 On GroupData6.dbo.Group589 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group522') 
 CREATE INDEX ix_QQNum_Group522 On GroupData6.dbo.Group522 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group590') 
 CREATE INDEX ix_QQNum_Group590 On GroupData6.dbo.Group590 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group523') 
 CREATE INDEX ix_QQNum_Group523 On GroupData6.dbo.Group523 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group591') 
 CREATE INDEX ix_QQNum_Group591 On GroupData6.dbo.Group591 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group524') 
 CREATE INDEX ix_QQNum_Group524 On GroupData6.dbo.Group524 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group592') 
 CREATE INDEX ix_QQNum_Group592 On GroupData6.dbo.Group592 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group525') 
 CREATE INDEX ix_QQNum_Group525 On GroupData6.dbo.Group525 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group593') 
 CREATE INDEX ix_QQNum_Group593 On GroupData6.dbo.Group593 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group526') 
 CREATE INDEX ix_QQNum_Group526 On GroupData6.dbo.Group526 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group594') 
 CREATE INDEX ix_QQNum_Group594 On GroupData6.dbo.Group594 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group527') 
 CREATE INDEX ix_QQNum_Group527 On GroupData6.dbo.Group527 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group595') 
 CREATE INDEX ix_QQNum_Group595 On GroupData6.dbo.Group595 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group528') 
 CREATE INDEX ix_QQNum_Group528 On GroupData6.dbo.Group528 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group596') 
 CREATE INDEX ix_QQNum_Group596 On GroupData6.dbo.Group596 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group529') 
 CREATE INDEX ix_QQNum_Group529 On GroupData6.dbo.Group529 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group597') 
 CREATE INDEX ix_QQNum_Group597 On GroupData6.dbo.Group597 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group530') 
 CREATE INDEX ix_QQNum_Group530 On GroupData6.dbo.Group530 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group598') 
 CREATE INDEX ix_QQNum_Group598 On GroupData6.dbo.Group598 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group531') 
 CREATE INDEX ix_QQNum_Group531 On GroupData6.dbo.Group531 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group599') 
 CREATE INDEX ix_QQNum_Group599 On GroupData6.dbo.Group599 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group532') 
 CREATE INDEX ix_QQNum_Group532 On GroupData6.dbo.Group532 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group600') 
 CREATE INDEX ix_QQNum_Group600 On GroupData6.dbo.Group600 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group533') 
 CREATE INDEX ix_QQNum_Group533 On GroupData6.dbo.Group533 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group534') 
 CREATE INDEX ix_QQNum_Group534 On GroupData6.dbo.Group534 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group535') 
 CREATE INDEX ix_QQNum_Group535 On GroupData6.dbo.Group535 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group536') 
 CREATE INDEX ix_QQNum_Group536 On GroupData6.dbo.Group536 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group537') 
 CREATE INDEX ix_QQNum_Group537 On GroupData6.dbo.Group537 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group538') 
 CREATE INDEX ix_QQNum_Group538 On GroupData6.dbo.Group538 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group539') 
 CREATE INDEX ix_QQNum_Group539 On GroupData6.dbo.Group539 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group540') 
 CREATE INDEX ix_QQNum_Group540 On GroupData6.dbo.Group540 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group541') 
 CREATE INDEX ix_QQNum_Group541 On GroupData6.dbo.Group541 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group542') 
 CREATE INDEX ix_QQNum_Group542 On GroupData6.dbo.Group542 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group543') 
 CREATE INDEX ix_QQNum_Group543 On GroupData6.dbo.Group543 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group544') 
 CREATE INDEX ix_QQNum_Group544 On GroupData6.dbo.Group544 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group545') 
 CREATE INDEX ix_QQNum_Group545 On GroupData6.dbo.Group545 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group546') 
 CREATE INDEX ix_QQNum_Group546 On GroupData6.dbo.Group546 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group547') 
 CREATE INDEX ix_QQNum_Group547 On GroupData6.dbo.Group547 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group548') 
 CREATE INDEX ix_QQNum_Group548 On GroupData6.dbo.Group548 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group549') 
 CREATE INDEX ix_QQNum_Group549 On GroupData6.dbo.Group549 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group550') 
 CREATE INDEX ix_QQNum_Group550 On GroupData6.dbo.Group550 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group551') 
 CREATE INDEX ix_QQNum_Group551 On GroupData6.dbo.Group551 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group552') 
 CREATE INDEX ix_QQNum_Group552 On GroupData6.dbo.Group552 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group553') 
 CREATE INDEX ix_QQNum_Group553 On GroupData6.dbo.Group553 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group554') 
 CREATE INDEX ix_QQNum_Group554 On GroupData6.dbo.Group554 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group555') 
 CREATE INDEX ix_QQNum_Group555 On GroupData6.dbo.Group555 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group556') 
 CREATE INDEX ix_QQNum_Group556 On GroupData6.dbo.Group556 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group557') 
 CREATE INDEX ix_QQNum_Group557 On GroupData6.dbo.Group557 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group558') 
 CREATE INDEX ix_QQNum_Group558 On GroupData6.dbo.Group558 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group559') 
 CREATE INDEX ix_QQNum_Group559 On GroupData6.dbo.Group559 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group560') 
 CREATE INDEX ix_QQNum_Group560 On GroupData6.dbo.Group560 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group561') 
 CREATE INDEX ix_QQNum_Group561 On GroupData6.dbo.Group561 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group562') 
 CREATE INDEX ix_QQNum_Group562 On GroupData6.dbo.Group562 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group563') 
 CREATE INDEX ix_QQNum_Group563 On GroupData6.dbo.Group563 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group564') 
 CREATE INDEX ix_QQNum_Group564 On GroupData6.dbo.Group564 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group565') 
 CREATE INDEX ix_QQNum_Group565 On GroupData6.dbo.Group565 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group566') 
 CREATE INDEX ix_QQNum_Group566 On GroupData6.dbo.Group566 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group567') 
 CREATE INDEX ix_QQNum_Group567 On GroupData6.dbo.Group567 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group568') 
 CREATE INDEX ix_QQNum_Group568 On GroupData6.dbo.Group568 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group501') 
 CREATE INDEX ix_QQNum_Group501 On GroupData6.dbo.Group501 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group569') 
 CREATE INDEX ix_QQNum_Group569 On GroupData6.dbo.Group569 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group502') 
 CREATE INDEX ix_QQNum_Group502 On GroupData6.dbo.Group502 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group570') 
 CREATE INDEX ix_QQNum_Group570 On GroupData6.dbo.Group570 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group503') 
 CREATE INDEX ix_QQNum_Group503 On GroupData6.dbo.Group503 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group571') 
 CREATE INDEX ix_QQNum_Group571 On GroupData6.dbo.Group571 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group504') 
 CREATE INDEX ix_QQNum_Group504 On GroupData6.dbo.Group504 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group572') 
 CREATE INDEX ix_QQNum_Group572 On GroupData6.dbo.Group572 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group505') 
 CREATE INDEX ix_QQNum_Group505 On GroupData6.dbo.Group505 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group573') 
 CREATE INDEX ix_QQNum_Group573 On GroupData6.dbo.Group573 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData6.dbo.sysindexes WHERE name = 'ix_QQNum_Group506') 
 CREATE INDEX ix_QQNum_Group506 On GroupData6.dbo.Group506 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group674') 
 CREATE INDEX ix_QQNum_Group674 On GroupData7.dbo.Group674 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group607') 
 CREATE INDEX ix_QQNum_Group607 On GroupData7.dbo.Group607 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group675') 
 CREATE INDEX ix_QQNum_Group675 On GroupData7.dbo.Group675 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group608') 
 CREATE INDEX ix_QQNum_Group608 On GroupData7.dbo.Group608 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group676') 
 CREATE INDEX ix_QQNum_Group676 On GroupData7.dbo.Group676 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group609') 
 CREATE INDEX ix_QQNum_Group609 On GroupData7.dbo.Group609 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group677') 
 CREATE INDEX ix_QQNum_Group677 On GroupData7.dbo.Group677 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group610') 
 CREATE INDEX ix_QQNum_Group610 On GroupData7.dbo.Group610 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group678') 
 CREATE INDEX ix_QQNum_Group678 On GroupData7.dbo.Group678 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group611') 
 CREATE INDEX ix_QQNum_Group611 On GroupData7.dbo.Group611 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group679') 
 CREATE INDEX ix_QQNum_Group679 On GroupData7.dbo.Group679 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group612') 
 CREATE INDEX ix_QQNum_Group612 On GroupData7.dbo.Group612 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group680') 
 CREATE INDEX ix_QQNum_Group680 On GroupData7.dbo.Group680 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group613') 
 CREATE INDEX ix_QQNum_Group613 On GroupData7.dbo.Group613 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group681') 
 CREATE INDEX ix_QQNum_Group681 On GroupData7.dbo.Group681 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group614') 
 CREATE INDEX ix_QQNum_Group614 On GroupData7.dbo.Group614 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group682') 
 CREATE INDEX ix_QQNum_Group682 On GroupData7.dbo.Group682 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group615') 
 CREATE INDEX ix_QQNum_Group615 On GroupData7.dbo.Group615 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group683') 
 CREATE INDEX ix_QQNum_Group683 On GroupData7.dbo.Group683 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group616') 
 CREATE INDEX ix_QQNum_Group616 On GroupData7.dbo.Group616 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group684') 
 CREATE INDEX ix_QQNum_Group684 On GroupData7.dbo.Group684 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group617') 
 CREATE INDEX ix_QQNum_Group617 On GroupData7.dbo.Group617 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group685') 
 CREATE INDEX ix_QQNum_Group685 On GroupData7.dbo.Group685 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group618') 
 CREATE INDEX ix_QQNum_Group618 On GroupData7.dbo.Group618 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group686') 
 CREATE INDEX ix_QQNum_Group686 On GroupData7.dbo.Group686 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group619') 
 CREATE INDEX ix_QQNum_Group619 On GroupData7.dbo.Group619 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group687') 
 CREATE INDEX ix_QQNum_Group687 On GroupData7.dbo.Group687 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group620') 
 CREATE INDEX ix_QQNum_Group620 On GroupData7.dbo.Group620 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group688') 
 CREATE INDEX ix_QQNum_Group688 On GroupData7.dbo.Group688 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group621') 
 CREATE INDEX ix_QQNum_Group621 On GroupData7.dbo.Group621 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group689') 
 CREATE INDEX ix_QQNum_Group689 On GroupData7.dbo.Group689 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group622') 
 CREATE INDEX ix_QQNum_Group622 On GroupData7.dbo.Group622 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group690') 
 CREATE INDEX ix_QQNum_Group690 On GroupData7.dbo.Group690 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group623') 
 CREATE INDEX ix_QQNum_Group623 On GroupData7.dbo.Group623 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group691') 
 CREATE INDEX ix_QQNum_Group691 On GroupData7.dbo.Group691 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group624') 
 CREATE INDEX ix_QQNum_Group624 On GroupData7.dbo.Group624 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group692') 
 CREATE INDEX ix_QQNum_Group692 On GroupData7.dbo.Group692 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group625') 
 CREATE INDEX ix_QQNum_Group625 On GroupData7.dbo.Group625 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group693') 
 CREATE INDEX ix_QQNum_Group693 On GroupData7.dbo.Group693 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group626') 
 CREATE INDEX ix_QQNum_Group626 On GroupData7.dbo.Group626 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group694') 
 CREATE INDEX ix_QQNum_Group694 On GroupData7.dbo.Group694 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group627') 
 CREATE INDEX ix_QQNum_Group627 On GroupData7.dbo.Group627 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group695') 
 CREATE INDEX ix_QQNum_Group695 On GroupData7.dbo.Group695 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group628') 
 CREATE INDEX ix_QQNum_Group628 On GroupData7.dbo.Group628 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group696') 
 CREATE INDEX ix_QQNum_Group696 On GroupData7.dbo.Group696 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group629') 
 CREATE INDEX ix_QQNum_Group629 On GroupData7.dbo.Group629 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group697') 
 CREATE INDEX ix_QQNum_Group697 On GroupData7.dbo.Group697 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group630') 
 CREATE INDEX ix_QQNum_Group630 On GroupData7.dbo.Group630 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group698') 
 CREATE INDEX ix_QQNum_Group698 On GroupData7.dbo.Group698 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group631') 
 CREATE INDEX ix_QQNum_Group631 On GroupData7.dbo.Group631 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group699') 
 CREATE INDEX ix_QQNum_Group699 On GroupData7.dbo.Group699 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group632') 
 CREATE INDEX ix_QQNum_Group632 On GroupData7.dbo.Group632 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group700') 
 CREATE INDEX ix_QQNum_Group700 On GroupData7.dbo.Group700 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group633') 
 CREATE INDEX ix_QQNum_Group633 On GroupData7.dbo.Group633 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group634') 
 CREATE INDEX ix_QQNum_Group634 On GroupData7.dbo.Group634 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group635') 
 CREATE INDEX ix_QQNum_Group635 On GroupData7.dbo.Group635 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group636') 
 CREATE INDEX ix_QQNum_Group636 On GroupData7.dbo.Group636 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group637') 
 CREATE INDEX ix_QQNum_Group637 On GroupData7.dbo.Group637 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group638') 
 CREATE INDEX ix_QQNum_Group638 On GroupData7.dbo.Group638 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group639') 
 CREATE INDEX ix_QQNum_Group639 On GroupData7.dbo.Group639 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group640') 
 CREATE INDEX ix_QQNum_Group640 On GroupData7.dbo.Group640 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group641') 
 CREATE INDEX ix_QQNum_Group641 On GroupData7.dbo.Group641 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group642') 
 CREATE INDEX ix_QQNum_Group642 On GroupData7.dbo.Group642 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group643') 
 CREATE INDEX ix_QQNum_Group643 On GroupData7.dbo.Group643 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group644') 
 CREATE INDEX ix_QQNum_Group644 On GroupData7.dbo.Group644 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group645') 
 CREATE INDEX ix_QQNum_Group645 On GroupData7.dbo.Group645 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group646') 
 CREATE INDEX ix_QQNum_Group646 On GroupData7.dbo.Group646 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group647') 
 CREATE INDEX ix_QQNum_Group647 On GroupData7.dbo.Group647 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group648') 
 CREATE INDEX ix_QQNum_Group648 On GroupData7.dbo.Group648 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group649') 
 CREATE INDEX ix_QQNum_Group649 On GroupData7.dbo.Group649 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group650') 
 CREATE INDEX ix_QQNum_Group650 On GroupData7.dbo.Group650 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group651') 
 CREATE INDEX ix_QQNum_Group651 On GroupData7.dbo.Group651 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group652') 
 CREATE INDEX ix_QQNum_Group652 On GroupData7.dbo.Group652 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group653') 
 CREATE INDEX ix_QQNum_Group653 On GroupData7.dbo.Group653 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group654') 
 CREATE INDEX ix_QQNum_Group654 On GroupData7.dbo.Group654 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group655') 
 CREATE INDEX ix_QQNum_Group655 On GroupData7.dbo.Group655 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group656') 
 CREATE INDEX ix_QQNum_Group656 On GroupData7.dbo.Group656 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group657') 
 CREATE INDEX ix_QQNum_Group657 On GroupData7.dbo.Group657 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group658') 
 CREATE INDEX ix_QQNum_Group658 On GroupData7.dbo.Group658 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group659') 
 CREATE INDEX ix_QQNum_Group659 On GroupData7.dbo.Group659 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group660') 
 CREATE INDEX ix_QQNum_Group660 On GroupData7.dbo.Group660 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group661') 
 CREATE INDEX ix_QQNum_Group661 On GroupData7.dbo.Group661 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group662') 
 CREATE INDEX ix_QQNum_Group662 On GroupData7.dbo.Group662 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group663') 
 CREATE INDEX ix_QQNum_Group663 On GroupData7.dbo.Group663 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group664') 
 CREATE INDEX ix_QQNum_Group664 On GroupData7.dbo.Group664 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group665') 
 CREATE INDEX ix_QQNum_Group665 On GroupData7.dbo.Group665 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group666') 
 CREATE INDEX ix_QQNum_Group666 On GroupData7.dbo.Group666 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group667') 
 CREATE INDEX ix_QQNum_Group667 On GroupData7.dbo.Group667 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group668') 
 CREATE INDEX ix_QQNum_Group668 On GroupData7.dbo.Group668 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group601') 
 CREATE INDEX ix_QQNum_Group601 On GroupData7.dbo.Group601 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group669') 
 CREATE INDEX ix_QQNum_Group669 On GroupData7.dbo.Group669 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group602') 
 CREATE INDEX ix_QQNum_Group602 On GroupData7.dbo.Group602 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group670') 
 CREATE INDEX ix_QQNum_Group670 On GroupData7.dbo.Group670 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group603') 
 CREATE INDEX ix_QQNum_Group603 On GroupData7.dbo.Group603 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group671') 
 CREATE INDEX ix_QQNum_Group671 On GroupData7.dbo.Group671 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group604') 
 CREATE INDEX ix_QQNum_Group604 On GroupData7.dbo.Group604 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group672') 
 CREATE INDEX ix_QQNum_Group672 On GroupData7.dbo.Group672 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group605') 
 CREATE INDEX ix_QQNum_Group605 On GroupData7.dbo.Group605 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group673') 
 CREATE INDEX ix_QQNum_Group673 On GroupData7.dbo.Group673 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData7.dbo.sysindexes WHERE name = 'ix_QQNum_Group606') 
 CREATE INDEX ix_QQNum_Group606 On GroupData7.dbo.Group606 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group774') 
 CREATE INDEX ix_QQNum_Group774 On GroupData8.dbo.Group774 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group707') 
 CREATE INDEX ix_QQNum_Group707 On GroupData8.dbo.Group707 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group775') 
 CREATE INDEX ix_QQNum_Group775 On GroupData8.dbo.Group775 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group708') 
 CREATE INDEX ix_QQNum_Group708 On GroupData8.dbo.Group708 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group776') 
 CREATE INDEX ix_QQNum_Group776 On GroupData8.dbo.Group776 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group709') 
 CREATE INDEX ix_QQNum_Group709 On GroupData8.dbo.Group709 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group777') 
 CREATE INDEX ix_QQNum_Group777 On GroupData8.dbo.Group777 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group710') 
 CREATE INDEX ix_QQNum_Group710 On GroupData8.dbo.Group710 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group778') 
 CREATE INDEX ix_QQNum_Group778 On GroupData8.dbo.Group778 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group711') 
 CREATE INDEX ix_QQNum_Group711 On GroupData8.dbo.Group711 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group779') 
 CREATE INDEX ix_QQNum_Group779 On GroupData8.dbo.Group779 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group712') 
 CREATE INDEX ix_QQNum_Group712 On GroupData8.dbo.Group712 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group780') 
 CREATE INDEX ix_QQNum_Group780 On GroupData8.dbo.Group780 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group713') 
 CREATE INDEX ix_QQNum_Group713 On GroupData8.dbo.Group713 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group781') 
 CREATE INDEX ix_QQNum_Group781 On GroupData8.dbo.Group781 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group714') 
 CREATE INDEX ix_QQNum_Group714 On GroupData8.dbo.Group714 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group782') 
 CREATE INDEX ix_QQNum_Group782 On GroupData8.dbo.Group782 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group715') 
 CREATE INDEX ix_QQNum_Group715 On GroupData8.dbo.Group715 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group783') 
 CREATE INDEX ix_QQNum_Group783 On GroupData8.dbo.Group783 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group716') 
 CREATE INDEX ix_QQNum_Group716 On GroupData8.dbo.Group716 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group784') 
 CREATE INDEX ix_QQNum_Group784 On GroupData8.dbo.Group784 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group717') 
 CREATE INDEX ix_QQNum_Group717 On GroupData8.dbo.Group717 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group785') 
 CREATE INDEX ix_QQNum_Group785 On GroupData8.dbo.Group785 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group718') 
 CREATE INDEX ix_QQNum_Group718 On GroupData8.dbo.Group718 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group786') 
 CREATE INDEX ix_QQNum_Group786 On GroupData8.dbo.Group786 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group719') 
 CREATE INDEX ix_QQNum_Group719 On GroupData8.dbo.Group719 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group787') 
 CREATE INDEX ix_QQNum_Group787 On GroupData8.dbo.Group787 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group720') 
 CREATE INDEX ix_QQNum_Group720 On GroupData8.dbo.Group720 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group788') 
 CREATE INDEX ix_QQNum_Group788 On GroupData8.dbo.Group788 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group721') 
 CREATE INDEX ix_QQNum_Group721 On GroupData8.dbo.Group721 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group789') 
 CREATE INDEX ix_QQNum_Group789 On GroupData8.dbo.Group789 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group722') 
 CREATE INDEX ix_QQNum_Group722 On GroupData8.dbo.Group722 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group790') 
 CREATE INDEX ix_QQNum_Group790 On GroupData8.dbo.Group790 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group723') 
 CREATE INDEX ix_QQNum_Group723 On GroupData8.dbo.Group723 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group791') 
 CREATE INDEX ix_QQNum_Group791 On GroupData8.dbo.Group791 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group724') 
 CREATE INDEX ix_QQNum_Group724 On GroupData8.dbo.Group724 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group792') 
 CREATE INDEX ix_QQNum_Group792 On GroupData8.dbo.Group792 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group725') 
 CREATE INDEX ix_QQNum_Group725 On GroupData8.dbo.Group725 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group793') 
 CREATE INDEX ix_QQNum_Group793 On GroupData8.dbo.Group793 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group726') 
 CREATE INDEX ix_QQNum_Group726 On GroupData8.dbo.Group726 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group794') 
 CREATE INDEX ix_QQNum_Group794 On GroupData8.dbo.Group794 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group727') 
 CREATE INDEX ix_QQNum_Group727 On GroupData8.dbo.Group727 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group795') 
 CREATE INDEX ix_QQNum_Group795 On GroupData8.dbo.Group795 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group728') 
 CREATE INDEX ix_QQNum_Group728 On GroupData8.dbo.Group728 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group796') 
 CREATE INDEX ix_QQNum_Group796 On GroupData8.dbo.Group796 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group729') 
 CREATE INDEX ix_QQNum_Group729 On GroupData8.dbo.Group729 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group797') 
 CREATE INDEX ix_QQNum_Group797 On GroupData8.dbo.Group797 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group730') 
 CREATE INDEX ix_QQNum_Group730 On GroupData8.dbo.Group730 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group798') 
 CREATE INDEX ix_QQNum_Group798 On GroupData8.dbo.Group798 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group731') 
 CREATE INDEX ix_QQNum_Group731 On GroupData8.dbo.Group731 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group799') 
 CREATE INDEX ix_QQNum_Group799 On GroupData8.dbo.Group799 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group732') 
 CREATE INDEX ix_QQNum_Group732 On GroupData8.dbo.Group732 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group800') 
 CREATE INDEX ix_QQNum_Group800 On GroupData8.dbo.Group800 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group733') 
 CREATE INDEX ix_QQNum_Group733 On GroupData8.dbo.Group733 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group734') 
 CREATE INDEX ix_QQNum_Group734 On GroupData8.dbo.Group734 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group735') 
 CREATE INDEX ix_QQNum_Group735 On GroupData8.dbo.Group735 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group736') 
 CREATE INDEX ix_QQNum_Group736 On GroupData8.dbo.Group736 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group737') 
 CREATE INDEX ix_QQNum_Group737 On GroupData8.dbo.Group737 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group738') 
 CREATE INDEX ix_QQNum_Group738 On GroupData8.dbo.Group738 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group739') 
 CREATE INDEX ix_QQNum_Group739 On GroupData8.dbo.Group739 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group740') 
 CREATE INDEX ix_QQNum_Group740 On GroupData8.dbo.Group740 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group741') 
 CREATE INDEX ix_QQNum_Group741 On GroupData8.dbo.Group741 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group742') 
 CREATE INDEX ix_QQNum_Group742 On GroupData8.dbo.Group742 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group743') 
 CREATE INDEX ix_QQNum_Group743 On GroupData8.dbo.Group743 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group744') 
 CREATE INDEX ix_QQNum_Group744 On GroupData8.dbo.Group744 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group745') 
 CREATE INDEX ix_QQNum_Group745 On GroupData8.dbo.Group745 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group746') 
 CREATE INDEX ix_QQNum_Group746 On GroupData8.dbo.Group746 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group747') 
 CREATE INDEX ix_QQNum_Group747 On GroupData8.dbo.Group747 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group748') 
 CREATE INDEX ix_QQNum_Group748 On GroupData8.dbo.Group748 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group749') 
 CREATE INDEX ix_QQNum_Group749 On GroupData8.dbo.Group749 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group750') 
 CREATE INDEX ix_QQNum_Group750 On GroupData8.dbo.Group750 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group751') 
 CREATE INDEX ix_QQNum_Group751 On GroupData8.dbo.Group751 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group752') 
 CREATE INDEX ix_QQNum_Group752 On GroupData8.dbo.Group752 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group753') 
 CREATE INDEX ix_QQNum_Group753 On GroupData8.dbo.Group753 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group754') 
 CREATE INDEX ix_QQNum_Group754 On GroupData8.dbo.Group754 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group755') 
 CREATE INDEX ix_QQNum_Group755 On GroupData8.dbo.Group755 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group756') 
 CREATE INDEX ix_QQNum_Group756 On GroupData8.dbo.Group756 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group757') 
 CREATE INDEX ix_QQNum_Group757 On GroupData8.dbo.Group757 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group758') 
 CREATE INDEX ix_QQNum_Group758 On GroupData8.dbo.Group758 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group759') 
 CREATE INDEX ix_QQNum_Group759 On GroupData8.dbo.Group759 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group760') 
 CREATE INDEX ix_QQNum_Group760 On GroupData8.dbo.Group760 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group761') 
 CREATE INDEX ix_QQNum_Group761 On GroupData8.dbo.Group761 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group762') 
 CREATE INDEX ix_QQNum_Group762 On GroupData8.dbo.Group762 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group763') 
 CREATE INDEX ix_QQNum_Group763 On GroupData8.dbo.Group763 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group764') 
 CREATE INDEX ix_QQNum_Group764 On GroupData8.dbo.Group764 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group765') 
 CREATE INDEX ix_QQNum_Group765 On GroupData8.dbo.Group765 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group766') 
 CREATE INDEX ix_QQNum_Group766 On GroupData8.dbo.Group766 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group767') 
 CREATE INDEX ix_QQNum_Group767 On GroupData8.dbo.Group767 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group768') 
 CREATE INDEX ix_QQNum_Group768 On GroupData8.dbo.Group768 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group701') 
 CREATE INDEX ix_QQNum_Group701 On GroupData8.dbo.Group701 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group769') 
 CREATE INDEX ix_QQNum_Group769 On GroupData8.dbo.Group769 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group702') 
 CREATE INDEX ix_QQNum_Group702 On GroupData8.dbo.Group702 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group770') 
 CREATE INDEX ix_QQNum_Group770 On GroupData8.dbo.Group770 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group703') 
 CREATE INDEX ix_QQNum_Group703 On GroupData8.dbo.Group703 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group771') 
 CREATE INDEX ix_QQNum_Group771 On GroupData8.dbo.Group771 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group704') 
 CREATE INDEX ix_QQNum_Group704 On GroupData8.dbo.Group704 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group772') 
 CREATE INDEX ix_QQNum_Group772 On GroupData8.dbo.Group772 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group705') 
 CREATE INDEX ix_QQNum_Group705 On GroupData8.dbo.Group705 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group773') 
 CREATE INDEX ix_QQNum_Group773 On GroupData8.dbo.Group773 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData8.dbo.sysindexes WHERE name = 'ix_QQNum_Group706') 
 CREATE INDEX ix_QQNum_Group706 On GroupData8.dbo.Group706 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group874') 
 CREATE INDEX ix_QQNum_Group874 On GroupData9.dbo.Group874 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group807') 
 CREATE INDEX ix_QQNum_Group807 On GroupData9.dbo.Group807 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group875') 
 CREATE INDEX ix_QQNum_Group875 On GroupData9.dbo.Group875 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group808') 
 CREATE INDEX ix_QQNum_Group808 On GroupData9.dbo.Group808 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group876') 
 CREATE INDEX ix_QQNum_Group876 On GroupData9.dbo.Group876 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group809') 
 CREATE INDEX ix_QQNum_Group809 On GroupData9.dbo.Group809 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group877') 
 CREATE INDEX ix_QQNum_Group877 On GroupData9.dbo.Group877 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group810') 
 CREATE INDEX ix_QQNum_Group810 On GroupData9.dbo.Group810 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group878') 
 CREATE INDEX ix_QQNum_Group878 On GroupData9.dbo.Group878 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group811') 
 CREATE INDEX ix_QQNum_Group811 On GroupData9.dbo.Group811 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group879') 
 CREATE INDEX ix_QQNum_Group879 On GroupData9.dbo.Group879 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group812') 
 CREATE INDEX ix_QQNum_Group812 On GroupData9.dbo.Group812 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group880') 
 CREATE INDEX ix_QQNum_Group880 On GroupData9.dbo.Group880 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group813') 
 CREATE INDEX ix_QQNum_Group813 On GroupData9.dbo.Group813 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group881') 
 CREATE INDEX ix_QQNum_Group881 On GroupData9.dbo.Group881 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group814') 
 CREATE INDEX ix_QQNum_Group814 On GroupData9.dbo.Group814 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group882') 
 CREATE INDEX ix_QQNum_Group882 On GroupData9.dbo.Group882 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group815') 
 CREATE INDEX ix_QQNum_Group815 On GroupData9.dbo.Group815 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group883') 
 CREATE INDEX ix_QQNum_Group883 On GroupData9.dbo.Group883 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group816') 
 CREATE INDEX ix_QQNum_Group816 On GroupData9.dbo.Group816 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group884') 
 CREATE INDEX ix_QQNum_Group884 On GroupData9.dbo.Group884 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group817') 
 CREATE INDEX ix_QQNum_Group817 On GroupData9.dbo.Group817 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group885') 
 CREATE INDEX ix_QQNum_Group885 On GroupData9.dbo.Group885 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group818') 
 CREATE INDEX ix_QQNum_Group818 On GroupData9.dbo.Group818 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group886') 
 CREATE INDEX ix_QQNum_Group886 On GroupData9.dbo.Group886 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group819') 
 CREATE INDEX ix_QQNum_Group819 On GroupData9.dbo.Group819 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group887') 
 CREATE INDEX ix_QQNum_Group887 On GroupData9.dbo.Group887 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group820') 
 CREATE INDEX ix_QQNum_Group820 On GroupData9.dbo.Group820 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group888') 
 CREATE INDEX ix_QQNum_Group888 On GroupData9.dbo.Group888 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group821') 
 CREATE INDEX ix_QQNum_Group821 On GroupData9.dbo.Group821 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group889') 
 CREATE INDEX ix_QQNum_Group889 On GroupData9.dbo.Group889 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group822') 
 CREATE INDEX ix_QQNum_Group822 On GroupData9.dbo.Group822 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group890') 
 CREATE INDEX ix_QQNum_Group890 On GroupData9.dbo.Group890 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group823') 
 CREATE INDEX ix_QQNum_Group823 On GroupData9.dbo.Group823 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group891') 
 CREATE INDEX ix_QQNum_Group891 On GroupData9.dbo.Group891 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group824') 
 CREATE INDEX ix_QQNum_Group824 On GroupData9.dbo.Group824 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group892') 
 CREATE INDEX ix_QQNum_Group892 On GroupData9.dbo.Group892 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group825') 
 CREATE INDEX ix_QQNum_Group825 On GroupData9.dbo.Group825 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group893') 
 CREATE INDEX ix_QQNum_Group893 On GroupData9.dbo.Group893 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group826') 
 CREATE INDEX ix_QQNum_Group826 On GroupData9.dbo.Group826 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group894') 
 CREATE INDEX ix_QQNum_Group894 On GroupData9.dbo.Group894 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group827') 
 CREATE INDEX ix_QQNum_Group827 On GroupData9.dbo.Group827 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group895') 
 CREATE INDEX ix_QQNum_Group895 On GroupData9.dbo.Group895 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group828') 
 CREATE INDEX ix_QQNum_Group828 On GroupData9.dbo.Group828 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group896') 
 CREATE INDEX ix_QQNum_Group896 On GroupData9.dbo.Group896 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group829') 
 CREATE INDEX ix_QQNum_Group829 On GroupData9.dbo.Group829 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group897') 
 CREATE INDEX ix_QQNum_Group897 On GroupData9.dbo.Group897 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group830') 
 CREATE INDEX ix_QQNum_Group830 On GroupData9.dbo.Group830 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group898') 
 CREATE INDEX ix_QQNum_Group898 On GroupData9.dbo.Group898 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group831') 
 CREATE INDEX ix_QQNum_Group831 On GroupData9.dbo.Group831 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group899') 
 CREATE INDEX ix_QQNum_Group899 On GroupData9.dbo.Group899 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group832') 
 CREATE INDEX ix_QQNum_Group832 On GroupData9.dbo.Group832 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group900') 
 CREATE INDEX ix_QQNum_Group900 On GroupData9.dbo.Group900 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group833') 
 CREATE INDEX ix_QQNum_Group833 On GroupData9.dbo.Group833 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group834') 
 CREATE INDEX ix_QQNum_Group834 On GroupData9.dbo.Group834 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group835') 
 CREATE INDEX ix_QQNum_Group835 On GroupData9.dbo.Group835 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group836') 
 CREATE INDEX ix_QQNum_Group836 On GroupData9.dbo.Group836 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group837') 
 CREATE INDEX ix_QQNum_Group837 On GroupData9.dbo.Group837 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group838') 
 CREATE INDEX ix_QQNum_Group838 On GroupData9.dbo.Group838 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group839') 
 CREATE INDEX ix_QQNum_Group839 On GroupData9.dbo.Group839 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group840') 
 CREATE INDEX ix_QQNum_Group840 On GroupData9.dbo.Group840 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group841') 
 CREATE INDEX ix_QQNum_Group841 On GroupData9.dbo.Group841 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group842') 
 CREATE INDEX ix_QQNum_Group842 On GroupData9.dbo.Group842 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group843') 
 CREATE INDEX ix_QQNum_Group843 On GroupData9.dbo.Group843 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group844') 
 CREATE INDEX ix_QQNum_Group844 On GroupData9.dbo.Group844 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group845') 
 CREATE INDEX ix_QQNum_Group845 On GroupData9.dbo.Group845 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group846') 
 CREATE INDEX ix_QQNum_Group846 On GroupData9.dbo.Group846 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group847') 
 CREATE INDEX ix_QQNum_Group847 On GroupData9.dbo.Group847 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group848') 
 CREATE INDEX ix_QQNum_Group848 On GroupData9.dbo.Group848 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group849') 
 CREATE INDEX ix_QQNum_Group849 On GroupData9.dbo.Group849 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group850') 
 CREATE INDEX ix_QQNum_Group850 On GroupData9.dbo.Group850 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group851') 
 CREATE INDEX ix_QQNum_Group851 On GroupData9.dbo.Group851 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group852') 
 CREATE INDEX ix_QQNum_Group852 On GroupData9.dbo.Group852 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group853') 
 CREATE INDEX ix_QQNum_Group853 On GroupData9.dbo.Group853 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group854') 
 CREATE INDEX ix_QQNum_Group854 On GroupData9.dbo.Group854 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group855') 
 CREATE INDEX ix_QQNum_Group855 On GroupData9.dbo.Group855 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group856') 
 CREATE INDEX ix_QQNum_Group856 On GroupData9.dbo.Group856 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group857') 
 CREATE INDEX ix_QQNum_Group857 On GroupData9.dbo.Group857 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group858') 
 CREATE INDEX ix_QQNum_Group858 On GroupData9.dbo.Group858 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group859') 
 CREATE INDEX ix_QQNum_Group859 On GroupData9.dbo.Group859 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group860') 
 CREATE INDEX ix_QQNum_Group860 On GroupData9.dbo.Group860 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group861') 
 CREATE INDEX ix_QQNum_Group861 On GroupData9.dbo.Group861 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group862') 
 CREATE INDEX ix_QQNum_Group862 On GroupData9.dbo.Group862 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group863') 
 CREATE INDEX ix_QQNum_Group863 On GroupData9.dbo.Group863 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group864') 
 CREATE INDEX ix_QQNum_Group864 On GroupData9.dbo.Group864 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group865') 
 CREATE INDEX ix_QQNum_Group865 On GroupData9.dbo.Group865 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group866') 
 CREATE INDEX ix_QQNum_Group866 On GroupData9.dbo.Group866 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group867') 
 CREATE INDEX ix_QQNum_Group867 On GroupData9.dbo.Group867 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group868') 
 CREATE INDEX ix_QQNum_Group868 On GroupData9.dbo.Group868 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group801') 
 CREATE INDEX ix_QQNum_Group801 On GroupData9.dbo.Group801 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group869') 
 CREATE INDEX ix_QQNum_Group869 On GroupData9.dbo.Group869 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group802') 
 CREATE INDEX ix_QQNum_Group802 On GroupData9.dbo.Group802 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group870') 
 CREATE INDEX ix_QQNum_Group870 On GroupData9.dbo.Group870 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group803') 
 CREATE INDEX ix_QQNum_Group803 On GroupData9.dbo.Group803 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group871') 
 CREATE INDEX ix_QQNum_Group871 On GroupData9.dbo.Group871 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group804') 
 CREATE INDEX ix_QQNum_Group804 On GroupData9.dbo.Group804 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group872') 
 CREATE INDEX ix_QQNum_Group872 On GroupData9.dbo.Group872 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group805') 
 CREATE INDEX ix_QQNum_Group805 On GroupData9.dbo.Group805 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group873') 
 CREATE INDEX ix_QQNum_Group873 On GroupData9.dbo.Group873 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData9.dbo.sysindexes WHERE name = 'ix_QQNum_Group806') 
 CREATE INDEX ix_QQNum_Group806 On GroupData9.dbo.Group806 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group974') 
 CREATE INDEX ix_QQNum_Group974 On GroupData10.dbo.Group974 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group907') 
 CREATE INDEX ix_QQNum_Group907 On GroupData10.dbo.Group907 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group975') 
 CREATE INDEX ix_QQNum_Group975 On GroupData10.dbo.Group975 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group908') 
 CREATE INDEX ix_QQNum_Group908 On GroupData10.dbo.Group908 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group976') 
 CREATE INDEX ix_QQNum_Group976 On GroupData10.dbo.Group976 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group909') 
 CREATE INDEX ix_QQNum_Group909 On GroupData10.dbo.Group909 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group977') 
 CREATE INDEX ix_QQNum_Group977 On GroupData10.dbo.Group977 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group910') 
 CREATE INDEX ix_QQNum_Group910 On GroupData10.dbo.Group910 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group978') 
 CREATE INDEX ix_QQNum_Group978 On GroupData10.dbo.Group978 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group911') 
 CREATE INDEX ix_QQNum_Group911 On GroupData10.dbo.Group911 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group979') 
 CREATE INDEX ix_QQNum_Group979 On GroupData10.dbo.Group979 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group912') 
 CREATE INDEX ix_QQNum_Group912 On GroupData10.dbo.Group912 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group980') 
 CREATE INDEX ix_QQNum_Group980 On GroupData10.dbo.Group980 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group913') 
 CREATE INDEX ix_QQNum_Group913 On GroupData10.dbo.Group913 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group981') 
 CREATE INDEX ix_QQNum_Group981 On GroupData10.dbo.Group981 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group914') 
 CREATE INDEX ix_QQNum_Group914 On GroupData10.dbo.Group914 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group982') 
 CREATE INDEX ix_QQNum_Group982 On GroupData10.dbo.Group982 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group915') 
 CREATE INDEX ix_QQNum_Group915 On GroupData10.dbo.Group915 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group983') 
 CREATE INDEX ix_QQNum_Group983 On GroupData10.dbo.Group983 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group916') 
 CREATE INDEX ix_QQNum_Group916 On GroupData10.dbo.Group916 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group984') 
 CREATE INDEX ix_QQNum_Group984 On GroupData10.dbo.Group984 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group917') 
 CREATE INDEX ix_QQNum_Group917 On GroupData10.dbo.Group917 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group985') 
 CREATE INDEX ix_QQNum_Group985 On GroupData10.dbo.Group985 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group918') 
 CREATE INDEX ix_QQNum_Group918 On GroupData10.dbo.Group918 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group986') 
 CREATE INDEX ix_QQNum_Group986 On GroupData10.dbo.Group986 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group919') 
 CREATE INDEX ix_QQNum_Group919 On GroupData10.dbo.Group919 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group987') 
 CREATE INDEX ix_QQNum_Group987 On GroupData10.dbo.Group987 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group920') 
 CREATE INDEX ix_QQNum_Group920 On GroupData10.dbo.Group920 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group988') 
 CREATE INDEX ix_QQNum_Group988 On GroupData10.dbo.Group988 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group921') 
 CREATE INDEX ix_QQNum_Group921 On GroupData10.dbo.Group921 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group989') 
 CREATE INDEX ix_QQNum_Group989 On GroupData10.dbo.Group989 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group922') 
 CREATE INDEX ix_QQNum_Group922 On GroupData10.dbo.Group922 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group990') 
 CREATE INDEX ix_QQNum_Group990 On GroupData10.dbo.Group990 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group923') 
 CREATE INDEX ix_QQNum_Group923 On GroupData10.dbo.Group923 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group991') 
 CREATE INDEX ix_QQNum_Group991 On GroupData10.dbo.Group991 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group924') 
 CREATE INDEX ix_QQNum_Group924 On GroupData10.dbo.Group924 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group992') 
 CREATE INDEX ix_QQNum_Group992 On GroupData10.dbo.Group992 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group925') 
 CREATE INDEX ix_QQNum_Group925 On GroupData10.dbo.Group925 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group993') 
 CREATE INDEX ix_QQNum_Group993 On GroupData10.dbo.Group993 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group926') 
 CREATE INDEX ix_QQNum_Group926 On GroupData10.dbo.Group926 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group994') 
 CREATE INDEX ix_QQNum_Group994 On GroupData10.dbo.Group994 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group927') 
 CREATE INDEX ix_QQNum_Group927 On GroupData10.dbo.Group927 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group995') 
 CREATE INDEX ix_QQNum_Group995 On GroupData10.dbo.Group995 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group928') 
 CREATE INDEX ix_QQNum_Group928 On GroupData10.dbo.Group928 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group996') 
 CREATE INDEX ix_QQNum_Group996 On GroupData10.dbo.Group996 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group929') 
 CREATE INDEX ix_QQNum_Group929 On GroupData10.dbo.Group929 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group997') 
 CREATE INDEX ix_QQNum_Group997 On GroupData10.dbo.Group997 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group930') 
 CREATE INDEX ix_QQNum_Group930 On GroupData10.dbo.Group930 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group998') 
 CREATE INDEX ix_QQNum_Group998 On GroupData10.dbo.Group998 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group931') 
 CREATE INDEX ix_QQNum_Group931 On GroupData10.dbo.Group931 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group999') 
 CREATE INDEX ix_QQNum_Group999 On GroupData10.dbo.Group999 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group932') 
 CREATE INDEX ix_QQNum_Group932 On GroupData10.dbo.Group932 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group1000') 
 CREATE INDEX ix_QQNum_Group1000 On GroupData10.dbo.Group1000 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group933') 
 CREATE INDEX ix_QQNum_Group933 On GroupData10.dbo.Group933 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group934') 
 CREATE INDEX ix_QQNum_Group934 On GroupData10.dbo.Group934 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group935') 
 CREATE INDEX ix_QQNum_Group935 On GroupData10.dbo.Group935 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group936') 
 CREATE INDEX ix_QQNum_Group936 On GroupData10.dbo.Group936 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group937') 
 CREATE INDEX ix_QQNum_Group937 On GroupData10.dbo.Group937 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group938') 
 CREATE INDEX ix_QQNum_Group938 On GroupData10.dbo.Group938 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group939') 
 CREATE INDEX ix_QQNum_Group939 On GroupData10.dbo.Group939 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group940') 
 CREATE INDEX ix_QQNum_Group940 On GroupData10.dbo.Group940 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group941') 
 CREATE INDEX ix_QQNum_Group941 On GroupData10.dbo.Group941 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group942') 
 CREATE INDEX ix_QQNum_Group942 On GroupData10.dbo.Group942 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group943') 
 CREATE INDEX ix_QQNum_Group943 On GroupData10.dbo.Group943 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group944') 
 CREATE INDEX ix_QQNum_Group944 On GroupData10.dbo.Group944 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group945') 
 CREATE INDEX ix_QQNum_Group945 On GroupData10.dbo.Group945 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group946') 
 CREATE INDEX ix_QQNum_Group946 On GroupData10.dbo.Group946 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group947') 
 CREATE INDEX ix_QQNum_Group947 On GroupData10.dbo.Group947 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group948') 
 CREATE INDEX ix_QQNum_Group948 On GroupData10.dbo.Group948 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group949') 
 CREATE INDEX ix_QQNum_Group949 On GroupData10.dbo.Group949 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group950') 
 CREATE INDEX ix_QQNum_Group950 On GroupData10.dbo.Group950 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group951') 
 CREATE INDEX ix_QQNum_Group951 On GroupData10.dbo.Group951 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group952') 
 CREATE INDEX ix_QQNum_Group952 On GroupData10.dbo.Group952 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group953') 
 CREATE INDEX ix_QQNum_Group953 On GroupData10.dbo.Group953 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group954') 
 CREATE INDEX ix_QQNum_Group954 On GroupData10.dbo.Group954 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group955') 
 CREATE INDEX ix_QQNum_Group955 On GroupData10.dbo.Group955 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group956') 
 CREATE INDEX ix_QQNum_Group956 On GroupData10.dbo.Group956 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group957') 
 CREATE INDEX ix_QQNum_Group957 On GroupData10.dbo.Group957 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group958') 
 CREATE INDEX ix_QQNum_Group958 On GroupData10.dbo.Group958 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group959') 
 CREATE INDEX ix_QQNum_Group959 On GroupData10.dbo.Group959 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group960') 
 CREATE INDEX ix_QQNum_Group960 On GroupData10.dbo.Group960 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group961') 
 CREATE INDEX ix_QQNum_Group961 On GroupData10.dbo.Group961 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group962') 
 CREATE INDEX ix_QQNum_Group962 On GroupData10.dbo.Group962 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group963') 
 CREATE INDEX ix_QQNum_Group963 On GroupData10.dbo.Group963 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group964') 
 CREATE INDEX ix_QQNum_Group964 On GroupData10.dbo.Group964 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group965') 
 CREATE INDEX ix_QQNum_Group965 On GroupData10.dbo.Group965 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group966') 
 CREATE INDEX ix_QQNum_Group966 On GroupData10.dbo.Group966 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group967') 
 CREATE INDEX ix_QQNum_Group967 On GroupData10.dbo.Group967 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group968') 
 CREATE INDEX ix_QQNum_Group968 On GroupData10.dbo.Group968 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group901') 
 CREATE INDEX ix_QQNum_Group901 On GroupData10.dbo.Group901 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group969') 
 CREATE INDEX ix_QQNum_Group969 On GroupData10.dbo.Group969 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group902') 
 CREATE INDEX ix_QQNum_Group902 On GroupData10.dbo.Group902 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group970') 
 CREATE INDEX ix_QQNum_Group970 On GroupData10.dbo.Group970 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group903') 
 CREATE INDEX ix_QQNum_Group903 On GroupData10.dbo.Group903 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group971') 
 CREATE INDEX ix_QQNum_Group971 On GroupData10.dbo.Group971 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group904') 
 CREATE INDEX ix_QQNum_Group904 On GroupData10.dbo.Group904 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group972') 
 CREATE INDEX ix_QQNum_Group972 On GroupData10.dbo.Group972 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group905') 
 CREATE INDEX ix_QQNum_Group905 On GroupData10.dbo.Group905 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group973') 
 CREATE INDEX ix_QQNum_Group973 On GroupData10.dbo.Group973 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData10.dbo.sysindexes WHERE name = 'ix_QQNum_Group906') 
 CREATE INDEX ix_QQNum_Group906 On GroupData10.dbo.Group906 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1074') 
 CREATE INDEX ix_QQNum_Group1074 On GroupData11.dbo.Group1074 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1007') 
 CREATE INDEX ix_QQNum_Group1007 On GroupData11.dbo.Group1007 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1075') 
 CREATE INDEX ix_QQNum_Group1075 On GroupData11.dbo.Group1075 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1008') 
 CREATE INDEX ix_QQNum_Group1008 On GroupData11.dbo.Group1008 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1076') 
 CREATE INDEX ix_QQNum_Group1076 On GroupData11.dbo.Group1076 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1009') 
 CREATE INDEX ix_QQNum_Group1009 On GroupData11.dbo.Group1009 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1077') 
 CREATE INDEX ix_QQNum_Group1077 On GroupData11.dbo.Group1077 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1010') 
 CREATE INDEX ix_QQNum_Group1010 On GroupData11.dbo.Group1010 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1078') 
 CREATE INDEX ix_QQNum_Group1078 On GroupData11.dbo.Group1078 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1011') 
 CREATE INDEX ix_QQNum_Group1011 On GroupData11.dbo.Group1011 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1079') 
 CREATE INDEX ix_QQNum_Group1079 On GroupData11.dbo.Group1079 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1012') 
 CREATE INDEX ix_QQNum_Group1012 On GroupData11.dbo.Group1012 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1080') 
 CREATE INDEX ix_QQNum_Group1080 On GroupData11.dbo.Group1080 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1013') 
 CREATE INDEX ix_QQNum_Group1013 On GroupData11.dbo.Group1013 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1081') 
 CREATE INDEX ix_QQNum_Group1081 On GroupData11.dbo.Group1081 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1014') 
 CREATE INDEX ix_QQNum_Group1014 On GroupData11.dbo.Group1014 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1082') 
 CREATE INDEX ix_QQNum_Group1082 On GroupData11.dbo.Group1082 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1015') 
 CREATE INDEX ix_QQNum_Group1015 On GroupData11.dbo.Group1015 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1083') 
 CREATE INDEX ix_QQNum_Group1083 On GroupData11.dbo.Group1083 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1016') 
 CREATE INDEX ix_QQNum_Group1016 On GroupData11.dbo.Group1016 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1084') 
 CREATE INDEX ix_QQNum_Group1084 On GroupData11.dbo.Group1084 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1017') 
 CREATE INDEX ix_QQNum_Group1017 On GroupData11.dbo.Group1017 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1085') 
 CREATE INDEX ix_QQNum_Group1085 On GroupData11.dbo.Group1085 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1018') 
 CREATE INDEX ix_QQNum_Group1018 On GroupData11.dbo.Group1018 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1086') 
 CREATE INDEX ix_QQNum_Group1086 On GroupData11.dbo.Group1086 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1019') 
 CREATE INDEX ix_QQNum_Group1019 On GroupData11.dbo.Group1019 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1087') 
 CREATE INDEX ix_QQNum_Group1087 On GroupData11.dbo.Group1087 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1020') 
 CREATE INDEX ix_QQNum_Group1020 On GroupData11.dbo.Group1020 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1088') 
 CREATE INDEX ix_QQNum_Group1088 On GroupData11.dbo.Group1088 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1021') 
 CREATE INDEX ix_QQNum_Group1021 On GroupData11.dbo.Group1021 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1089') 
 CREATE INDEX ix_QQNum_Group1089 On GroupData11.dbo.Group1089 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1022') 
 CREATE INDEX ix_QQNum_Group1022 On GroupData11.dbo.Group1022 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1090') 
 CREATE INDEX ix_QQNum_Group1090 On GroupData11.dbo.Group1090 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1023') 
 CREATE INDEX ix_QQNum_Group1023 On GroupData11.dbo.Group1023 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1091') 
 CREATE INDEX ix_QQNum_Group1091 On GroupData11.dbo.Group1091 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1024') 
 CREATE INDEX ix_QQNum_Group1024 On GroupData11.dbo.Group1024 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1092') 
 CREATE INDEX ix_QQNum_Group1092 On GroupData11.dbo.Group1092 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1025') 
 CREATE INDEX ix_QQNum_Group1025 On GroupData11.dbo.Group1025 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1093') 
 CREATE INDEX ix_QQNum_Group1093 On GroupData11.dbo.Group1093 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1026') 
 CREATE INDEX ix_QQNum_Group1026 On GroupData11.dbo.Group1026 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1094') 
 CREATE INDEX ix_QQNum_Group1094 On GroupData11.dbo.Group1094 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1027') 
 CREATE INDEX ix_QQNum_Group1027 On GroupData11.dbo.Group1027 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1095') 
 CREATE INDEX ix_QQNum_Group1095 On GroupData11.dbo.Group1095 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1028') 
 CREATE INDEX ix_QQNum_Group1028 On GroupData11.dbo.Group1028 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1096') 
 CREATE INDEX ix_QQNum_Group1096 On GroupData11.dbo.Group1096 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1029') 
 CREATE INDEX ix_QQNum_Group1029 On GroupData11.dbo.Group1029 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1097') 
 CREATE INDEX ix_QQNum_Group1097 On GroupData11.dbo.Group1097 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1030') 
 CREATE INDEX ix_QQNum_Group1030 On GroupData11.dbo.Group1030 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1098') 
 CREATE INDEX ix_QQNum_Group1098 On GroupData11.dbo.Group1098 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1031') 
 CREATE INDEX ix_QQNum_Group1031 On GroupData11.dbo.Group1031 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1099') 
 CREATE INDEX ix_QQNum_Group1099 On GroupData11.dbo.Group1099 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1032') 
 CREATE INDEX ix_QQNum_Group1032 On GroupData11.dbo.Group1032 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1100') 
 CREATE INDEX ix_QQNum_Group1100 On GroupData11.dbo.Group1100 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1033') 
 CREATE INDEX ix_QQNum_Group1033 On GroupData11.dbo.Group1033 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1034') 
 CREATE INDEX ix_QQNum_Group1034 On GroupData11.dbo.Group1034 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1035') 
 CREATE INDEX ix_QQNum_Group1035 On GroupData11.dbo.Group1035 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1036') 
 CREATE INDEX ix_QQNum_Group1036 On GroupData11.dbo.Group1036 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1037') 
 CREATE INDEX ix_QQNum_Group1037 On GroupData11.dbo.Group1037 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1038') 
 CREATE INDEX ix_QQNum_Group1038 On GroupData11.dbo.Group1038 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1039') 
 CREATE INDEX ix_QQNum_Group1039 On GroupData11.dbo.Group1039 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1040') 
 CREATE INDEX ix_QQNum_Group1040 On GroupData11.dbo.Group1040 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1041') 
 CREATE INDEX ix_QQNum_Group1041 On GroupData11.dbo.Group1041 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1042') 
 CREATE INDEX ix_QQNum_Group1042 On GroupData11.dbo.Group1042 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1043') 
 CREATE INDEX ix_QQNum_Group1043 On GroupData11.dbo.Group1043 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1044') 
 CREATE INDEX ix_QQNum_Group1044 On GroupData11.dbo.Group1044 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1045') 
 CREATE INDEX ix_QQNum_Group1045 On GroupData11.dbo.Group1045 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1046') 
 CREATE INDEX ix_QQNum_Group1046 On GroupData11.dbo.Group1046 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1047') 
 CREATE INDEX ix_QQNum_Group1047 On GroupData11.dbo.Group1047 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1048') 
 CREATE INDEX ix_QQNum_Group1048 On GroupData11.dbo.Group1048 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1049') 
 CREATE INDEX ix_QQNum_Group1049 On GroupData11.dbo.Group1049 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1050') 
 CREATE INDEX ix_QQNum_Group1050 On GroupData11.dbo.Group1050 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1051') 
 CREATE INDEX ix_QQNum_Group1051 On GroupData11.dbo.Group1051 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1052') 
 CREATE INDEX ix_QQNum_Group1052 On GroupData11.dbo.Group1052 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1053') 
 CREATE INDEX ix_QQNum_Group1053 On GroupData11.dbo.Group1053 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1054') 
 CREATE INDEX ix_QQNum_Group1054 On GroupData11.dbo.Group1054 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1055') 
 CREATE INDEX ix_QQNum_Group1055 On GroupData11.dbo.Group1055 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1056') 
 CREATE INDEX ix_QQNum_Group1056 On GroupData11.dbo.Group1056 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1057') 
 CREATE INDEX ix_QQNum_Group1057 On GroupData11.dbo.Group1057 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1058') 
 CREATE INDEX ix_QQNum_Group1058 On GroupData11.dbo.Group1058 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1059') 
 CREATE INDEX ix_QQNum_Group1059 On GroupData11.dbo.Group1059 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1060') 
 CREATE INDEX ix_QQNum_Group1060 On GroupData11.dbo.Group1060 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1061') 
 CREATE INDEX ix_QQNum_Group1061 On GroupData11.dbo.Group1061 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1062') 
 CREATE INDEX ix_QQNum_Group1062 On GroupData11.dbo.Group1062 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1063') 
 CREATE INDEX ix_QQNum_Group1063 On GroupData11.dbo.Group1063 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1064') 
 CREATE INDEX ix_QQNum_Group1064 On GroupData11.dbo.Group1064 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1065') 
 CREATE INDEX ix_QQNum_Group1065 On GroupData11.dbo.Group1065 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1066') 
 CREATE INDEX ix_QQNum_Group1066 On GroupData11.dbo.Group1066 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1067') 
 CREATE INDEX ix_QQNum_Group1067 On GroupData11.dbo.Group1067 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1068') 
 CREATE INDEX ix_QQNum_Group1068 On GroupData11.dbo.Group1068 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1001') 
 CREATE INDEX ix_QQNum_Group1001 On GroupData11.dbo.Group1001 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1069') 
 CREATE INDEX ix_QQNum_Group1069 On GroupData11.dbo.Group1069 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1002') 
 CREATE INDEX ix_QQNum_Group1002 On GroupData11.dbo.Group1002 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1070') 
 CREATE INDEX ix_QQNum_Group1070 On GroupData11.dbo.Group1070 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1003') 
 CREATE INDEX ix_QQNum_Group1003 On GroupData11.dbo.Group1003 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1071') 
 CREATE INDEX ix_QQNum_Group1071 On GroupData11.dbo.Group1071 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1004') 
 CREATE INDEX ix_QQNum_Group1004 On GroupData11.dbo.Group1004 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1072') 
 CREATE INDEX ix_QQNum_Group1072 On GroupData11.dbo.Group1072 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1005') 
 CREATE INDEX ix_QQNum_Group1005 On GroupData11.dbo.Group1005 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1073') 
 CREATE INDEX ix_QQNum_Group1073 On GroupData11.dbo.Group1073 (QQNum);
IF not EXISTS (SELECT indid FROM GroupData11.dbo.sysindexes WHERE name = 'ix_QQNum_Group1006') 
 CREATE INDEX ix_QQNum_Group1006 On GroupData11.dbo.Group1006 (QQNum);
;

下面是查询代码：（出处： http://bbs.csdn.net/topics/390651370?page=1）有错误的，自己修改，我只贴源码

declare @QQNum int = 343056143
declare @sql varchar(8000)
declare @dbIdx int = 1

-- Author:	 <天山雪王>
-- Email:	 <easy66@live.com>
-- Create date: <2013-11-21>
-- Description:	<输入QQ号，输出其所加群>
-- Note:        <不支持超过int长度的QQ号>

if OBJECT_ID('tempdb.dbo.#QunList') is not null
drop table #QunList
if OBJECT_ID('tempdb.dbo.#QunDetail') is not null
drop table #QunDetail

create table #QunList
(
QQNum int,
Nick varchar(20),
Age int,
Gender int,
Auth int,
QunNum int,
Title varchar(22),
QunText varchar(80)
)
create table #QunDetail
(
QunNum int,
Title varchar(22),
QunText varchar(80)
)

-- Search QunList

while @dbIdx <= 11
begin
declare @tblIdx int = 1
declare @tblName varchar(50)

while @tblIdx <= 100
begin
set @tblName = 'GroupData' + CONVERT(varchar(2), @dbIdx) + 'on.dbo.Group'
set @tblName += CONVERT(varchar(5), (@dbIdx - 1) * 100 + @tblIdx)

set @sql = 'select QQNum, Nick, Age,Gender, Auth, QunNum from '
set @sql += @tblName + ' where QQNum=' + CONVERT(varchar(15), @QQNum)

insert into #QunList(QQNum, Nick,Age,Gender,Auth,QunNum)  exec(@sql)

print @tblname + ' OK'

set @tblIdx += 1
end

set @dbIdx += 1
end

-- Search QunDetail

declare @QunNum int
declare cur_Qun cursor 
for select QunNum from #QunList

open cur_Qun
fetch next from cur_Qun into @QunNum

while @@FETCH_STATUS = 0
begin
set @sql = 'select QunNum,Title,QunText from QunInfo' + CONVERT(varchar(5), @QunNum / 10000000 + 1) + 'on.dbo.'
set @sql += 'QunList' + CONVERT(varchar(10), @QunNum / 1000000 + 1) + ' where QunNum=' + Convert(varchar(20),@QunNum)

insert into #QunDetail exec(@sql)

fetch next from cur_Qun into @QunNum
end

close cur_Qun
deallocate cur_Qun

-- combine QunList with QunDetail

update #QunList set Title = #QunDetail.Title,QunText=#QunDetail.QunText 
from #QunDetail
where #QunList.QunNum = #QunDetail.QunNum

select * from #QunList

另附一个建立索引方法（出处： http://ozbikoglan.4.yax.la/thread-301-1-1.html）未测试自己测试

自问自答
declare @QQNum int = 343056143
declare @sql varchar(8000)
declare @dbIdx int = 1
declare @indexName varchar(8000)

-- creat index
declare @tblIdx int = 1
while @dbIdx <= 11
begin

    declare @tblName varchar(50)
     
    while @tblIdx <= 100
    begin
        set @tblName = 'GroupData' + CONVERT(varchar(2), @dbIdx) + '.dbo.Group'
        set @tblName += CONVERT(varchar(5), (@dbIdx - 1) * 100 + @tblIdx)
         
        set @indexName =  'Group'
        set @indexName += CONVERT(varchar(5), (@dbIdx - 1) * 100 + @tblIdx)
         
        set @sql = 'CREATE INDEX '+ @indexName + ' ON '+  @tblName+'(QQNum)'
                print @sql
                exec(@sql)

 
        print @tblname + ' OK'
                 
        set @tblIdx += 1
    end
    set @tblIdx =1
    set @dbIdx += 1
end

set @dbIdx =1
set @tblIdx =1
 
while @dbIdx <= 11
begin

    declare @tblName varchar(50)
     
    while @tblIdx <= 10
    begin
        set @tblName = 'QunInfo' + CONVERT(varchar(2), @dbIdx) + '.dbo.QunList'
        set @tblName += CONVERT(varchar(4), (@dbIdx - 1) * 10 + @tblIdx)
         
        set @indexName =  'QunList'
        set @indexName += CONVERT(varchar(4), (@dbIdx - 1) * 10 + @tblIdx)
         
        set @sql = 'CREATE INDEX '+ @indexName + ' ON '+  @tblName+'(QunNum)'
                print @sql
                exec(@sql)

 
        print @tblname + ' OK'
                 
        set @tblIdx += 1
    end
    set @tblIdx =1
    set @dbIdx += 1
end

kb623456

关注

0
点赞
踩
2

收藏

觉得还不错? 一键收藏
0
评论
SQLsever2008群数据建立索引与查询

建立索引部分（出处：http://www.rover12421.com/2013/12/01/qq-leaked-database-query-optimization.html）我只选了一部分，时间大概几小时吧-----------------------------------------------QQ数据库查询优化--By Rover12421--执行完改SQL脚本,可以通过pr
复制链接

扫一扫