建立索引部分(出处: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