1 CREATE INDEX [i_bs] ON [SubInd_ch10]([batch_id], [subsnp_id])
4 CREATE INDEX [i_ind_ss] ON [SubInd_ch10]([submitted_ind_id], [subsnp_id], [gty_id])
8 CREATE INDEX [i_bs] ON [SubInd_ch11]([batch_id], [subsnp_id])
11 CREATE INDEX [i_ind_ss] ON [SubInd_ch11]([submitted_ind_id], [subsnp_id], [gty_id])
15 CREATE INDEX [i_bs] ON [SubInd_ch12]([batch_id], [subsnp_id])
18 CREATE INDEX [i_ind_ss] ON [SubInd_ch12]([submitted_ind_id], [subsnp_id], [gty_id])
22 CREATE INDEX [i_bs] ON [SubInd_ch13]([batch_id], [subsnp_id])
25 CREATE INDEX [i_ind_ss] ON [SubInd_ch13]([submitted_ind_id], [subsnp_id], [gty_id])
29 CREATE INDEX [i_bs] ON [SubInd_ch14]([batch_id], [subsnp_id])
32 CREATE INDEX [i_ind_ss] ON [SubInd_ch14]([submitted_ind_id], [subsnp_id], [gty_id])
36 CREATE INDEX [i_bs] ON [SubInd_ch15]([batch_id], [subsnp_id])
39 CREATE INDEX [i_ind_ss] ON [SubInd_ch15]([submitted_ind_id], [subsnp_id], [gty_id])
43 CREATE INDEX [i_bs] ON [SubInd_ch16]([batch_id], [subsnp_id])
46 CREATE INDEX [i_ind_ss] ON [SubInd_ch16]([submitted_ind_id], [subsnp_id], [gty_id])
50 CREATE INDEX [i_bs] ON [SubInd_ch17]([batch_id], [subsnp_id])
53 CREATE INDEX [i_ind_ss] ON [SubInd_ch17]([submitted_ind_id], [subsnp_id], [gty_id])
57 CREATE INDEX [i_bs] ON [SubInd_ch18]([batch_id], [subsnp_id])
60 CREATE INDEX [i_ind_ss] ON [SubInd_ch18]([submitted_ind_id], [subsnp_id], [gty_id])
64 CREATE INDEX [i_bs] ON [SubInd_ch19]([batch_id], [subsnp_id])
67 CREATE INDEX [i_ind_ss] ON [SubInd_ch19]([submitted_ind_id], [subsnp_id], [gty_id])
71 CREATE INDEX [i_bs] ON [SubInd_ch20]([batch_id], [subsnp_id])
74 CREATE INDEX [i_ind_ss] ON [SubInd_ch20]([submitted_ind_id], [subsnp_id], [gty_id])
78 CREATE INDEX [i_bs] ON [SubInd_ch21]([batch_id], [subsnp_id])
81 CREATE INDEX [i_ind_ss] ON [SubInd_ch21]([submitted_ind_id], [subsnp_id], [gty_id])
85 CREATE INDEX [i_bs] ON [SubInd_ch22]([batch_id], [subsnp_id])
88 CREATE INDEX [i_ind_ss] ON [SubInd_ch22]([submitted_ind_id], [subsnp_id], [gty_id])
92 CREATE INDEX [i_bs] ON [SubInd_ch8]([batch_id], [subsnp_id])
95 CREATE INDEX [i_ind_ss] ON [SubInd_ch8]([submitted_ind_id], [subsnp_id], [gty_id])
99 CREATE INDEX [i_bs] ON [SubInd_ch9]([batch_id], [subsnp_id])
102 CREATE INDEX [i_ind_ss] ON [SubInd_ch9]([submitted_ind_id], [subsnp_id], [gty_id])
106 CREATE INDEX [i_bs] ON [SubInd_chAltOnly]([batch_id], [subsnp_id])
109 CREATE INDEX [i_ind_ss] ON [SubInd_chAltOnly]([submitted_ind_id], [subsnp_id], [gty_id])
113 CREATE INDEX [i_bs] ON [SubInd_chMT]([batch_id], [subsnp_id])
116 CREATE INDEX [i_ind_ss] ON [SubInd_chMT]([submitted_ind_id], [subsnp_id], [gty_id])
120 CREATE INDEX [i_bs] ON [SubInd_chMulti]([batch_id], [subsnp_id])
123 CREATE INDEX [i_ind_ss] ON [SubInd_chMulti]([submitted_ind_id], [subsnp_id], [gty_id])
127 CREATE INDEX [i_batch_ss] ON [SubInd_chNewSs]([batch_id], [subsnp_id])
130 CREATE INDEX [i_ind_ss] ON [SubInd_chNewSs]([submitted_ind_id], [subsnp_id], [gty_id])
134 CREATE INDEX [i_bs] ON [SubInd_chNotOn]([batch_id], [subsnp_id])
137 CREATE INDEX [i_ind_ss] ON [SubInd_chNotOn]([submitted_ind_id], [subsnp_id], [gty_id])
141 CREATE INDEX [i_bs] ON [SubInd_chPAR]([batch_id], [subsnp_id])
144 CREATE INDEX [i_ind_ss] ON [SubInd_chPAR]([submitted_ind_id], [subsnp_id], [gty_id])
148 CREATE INDEX [i_bs] ON [SubInd_chUn]([batch_id], [subsnp_id])
151 CREATE INDEX [i_ind_ss] ON [SubInd_chUn]([submitted_ind_id], [subsnp_id], [gty_id])
155 CREATE INDEX [i_bs] ON [SubInd_chX]([batch_id], [subsnp_id])
158 CREATE INDEX [i_ind_ss] ON [SubInd_chX]([submitted_ind_id], [subsnp_id], [gty_id])
162 CREATE INDEX [i_bs] ON [SubInd_chY]([batch_id], [subsnp_id])
165 CREATE INDEX [i_ind_ss] ON [SubInd_chY]([submitted_ind_id], [subsnp_id], [gty_id])
169 CREATE CLUSTERED INDEX [i_b_size] ON [dn_table_rowcount]([build_id] DESC , [reserved_KB_spaceused] DESC )