1 CREATE INDEX [i_bs] ON [SubInd_ch1]([batch_id], [subsnp_id])
4 CREATE INDEX [i_ind_ss] ON [SubInd_ch1]([submitted_ind_id], [subsnp_id], [gty_id])
8 CREATE INDEX [i_bs] ON [SubInd_ch2]([batch_id], [subsnp_id])
11 CREATE INDEX [i_ind_ss] ON [SubInd_ch2]([submitted_ind_id], [subsnp_id], [gty_id])
15 CREATE INDEX [i_bs] ON [SubInd_ch3]([batch_id], [subsnp_id])
18 CREATE INDEX [i_ind_ss] ON [SubInd_ch3]([submitted_ind_id], [subsnp_id], [gty_id])
22 CREATE INDEX [i_bs] ON [SubInd_ch4]([batch_id], [subsnp_id])
25 CREATE INDEX [i_ind_ss] ON [SubInd_ch4]([submitted_ind_id], [subsnp_id], [gty_id])
29 CREATE INDEX [i_bs] ON [SubInd_ch5]([batch_id], [subsnp_id])
32 CREATE INDEX [i_ind_ss] ON [SubInd_ch5]([submitted_ind_id], [subsnp_id], [gty_id])
36 CREATE INDEX [i_bs] ON [SubInd_ch6]([batch_id], [subsnp_id])
39 CREATE INDEX [i_ind_ss] ON [SubInd_ch6]([submitted_ind_id], [subsnp_id], [gty_id])
43 CREATE INDEX [i_bs] ON [SubInd_ch7]([batch_id], [subsnp_id])
46 CREATE INDEX [i_ind_ss] ON [SubInd_ch7]([submitted_ind_id], [subsnp_id], [gty_id])
50 CREATE CLUSTERED INDEX [i_b_size] ON [dn_table_rowcount]([build_id] DESC , [reserved_KB_spaceused] DESC )