1 CREATE NONCLUSTERED INDEX [i_bs] ON [SubInd_ch10] ([batch_id] ASC,[subsnp_id] ASC)
\r
3 CREATE NONCLUSTERED INDEX [i_ind_ss] ON [SubInd_ch10] ([submitted_ind_id] ASC,[subsnp_id] ASC,[gty_id] ASC)
\r
6 CREATE NONCLUSTERED INDEX [i_bs] ON [SubInd_ch11] ([batch_id] ASC,[subsnp_id] ASC)
\r
8 CREATE NONCLUSTERED INDEX [i_ind_ss] ON [SubInd_ch11] ([submitted_ind_id] ASC,[subsnp_id] ASC,[gty_id] ASC)
\r
11 CREATE NONCLUSTERED INDEX [i_bs] ON [SubInd_ch12] ([batch_id] ASC,[subsnp_id] ASC)
\r
13 CREATE NONCLUSTERED INDEX [i_ind_ss] ON [SubInd_ch12] ([submitted_ind_id] ASC,[subsnp_id] ASC,[gty_id] ASC)
\r
16 CREATE NONCLUSTERED INDEX [i_bs] ON [SubInd_ch13] ([batch_id] ASC,[subsnp_id] ASC)
\r
18 CREATE NONCLUSTERED INDEX [i_ind_ss] ON [SubInd_ch13] ([submitted_ind_id] ASC,[subsnp_id] ASC,[gty_id] ASC)
\r
21 CREATE NONCLUSTERED INDEX [i_bs] ON [SubInd_ch14] ([batch_id] ASC,[subsnp_id] ASC)
\r
23 CREATE NONCLUSTERED INDEX [i_ind_ss] ON [SubInd_ch14] ([submitted_ind_id] ASC,[subsnp_id] ASC,[gty_id] ASC)
\r
26 CREATE NONCLUSTERED INDEX [i_bs] ON [SubInd_ch15] ([batch_id] ASC,[subsnp_id] ASC)
\r
28 CREATE NONCLUSTERED INDEX [i_ind_ss] ON [SubInd_ch15] ([submitted_ind_id] ASC,[subsnp_id] ASC,[gty_id] ASC)
\r
31 CREATE NONCLUSTERED INDEX [i_bs] ON [SubInd_ch16] ([batch_id] ASC,[subsnp_id] ASC)
\r
33 CREATE NONCLUSTERED INDEX [i_ind_ss] ON [SubInd_ch16] ([submitted_ind_id] ASC,[subsnp_id] ASC,[gty_id] ASC)
\r
36 CREATE NONCLUSTERED INDEX [i_bs] ON [SubInd_ch17] ([batch_id] ASC,[subsnp_id] ASC)
\r
38 CREATE NONCLUSTERED INDEX [i_ind_ss] ON [SubInd_ch17] ([submitted_ind_id] ASC,[subsnp_id] ASC,[gty_id] ASC)
\r
41 CREATE NONCLUSTERED INDEX [i_bs] ON [SubInd_ch18] ([batch_id] ASC,[subsnp_id] ASC)
\r
43 CREATE NONCLUSTERED INDEX [i_ind_ss] ON [SubInd_ch18] ([submitted_ind_id] ASC,[subsnp_id] ASC,[gty_id] ASC)
\r
46 CREATE NONCLUSTERED INDEX [i_bs] ON [SubInd_ch19] ([batch_id] ASC,[subsnp_id] ASC)
\r
48 CREATE NONCLUSTERED INDEX [i_ind_ss] ON [SubInd_ch19] ([submitted_ind_id] ASC,[subsnp_id] ASC,[gty_id] ASC)
\r
51 CREATE NONCLUSTERED INDEX [i_bs] ON [SubInd_ch20] ([batch_id] ASC,[subsnp_id] ASC)
\r
53 CREATE NONCLUSTERED INDEX [i_ind_ss] ON [SubInd_ch20] ([submitted_ind_id] ASC,[subsnp_id] ASC,[gty_id] ASC)
\r
56 CREATE NONCLUSTERED INDEX [i_bs] ON [SubInd_ch21] ([batch_id] ASC,[subsnp_id] ASC)
\r
58 CREATE NONCLUSTERED INDEX [i_ind_ss] ON [SubInd_ch21] ([submitted_ind_id] ASC,[subsnp_id] ASC,[gty_id] ASC)
\r
61 CREATE NONCLUSTERED INDEX [i_bs] ON [SubInd_ch22] ([batch_id] ASC,[subsnp_id] ASC)
\r
63 CREATE NONCLUSTERED INDEX [i_ind_ss] ON [SubInd_ch22] ([submitted_ind_id] ASC,[subsnp_id] ASC,[gty_id] ASC)
\r
66 CREATE NONCLUSTERED INDEX [i_bs] ON [SubInd_ch8] ([batch_id] ASC,[subsnp_id] ASC)
\r
68 CREATE NONCLUSTERED INDEX [i_ind_ss] ON [SubInd_ch8] ([submitted_ind_id] ASC,[subsnp_id] ASC,[gty_id] ASC)
\r
71 CREATE NONCLUSTERED INDEX [i_bs] ON [SubInd_ch9] ([batch_id] ASC,[subsnp_id] ASC)
\r
73 CREATE NONCLUSTERED INDEX [i_ind_ss] ON [SubInd_ch9] ([submitted_ind_id] ASC,[subsnp_id] ASC,[gty_id] ASC)
\r
76 CREATE NONCLUSTERED INDEX [i_bs] ON [SubInd_chAltOnly] ([batch_id] ASC,[subsnp_id] ASC)
\r
78 CREATE NONCLUSTERED INDEX [i_ind_ss] ON [SubInd_chAltOnly] ([submitted_ind_id] ASC,[subsnp_id] ASC,[gty_id] ASC)
\r
81 CREATE NONCLUSTERED INDEX [i_bs] ON [SubInd_chMT] ([batch_id] ASC,[subsnp_id] ASC)
\r
83 CREATE NONCLUSTERED INDEX [i_ind_ss] ON [SubInd_chMT] ([submitted_ind_id] ASC,[subsnp_id] ASC,[gty_id] ASC)
\r
86 CREATE NONCLUSTERED INDEX [i_bs] ON [SubInd_chMulti] ([batch_id] ASC,[subsnp_id] ASC)
\r
88 CREATE NONCLUSTERED INDEX [i_ind_ss] ON [SubInd_chMulti] ([submitted_ind_id] ASC,[subsnp_id] ASC,[gty_id] ASC)
\r
91 CREATE NONCLUSTERED INDEX [i_batch_ss] ON [SubInd_chNewSs] ([batch_id] ASC,[subsnp_id] ASC)
\r
93 CREATE NONCLUSTERED INDEX [i_ind_ss] ON [SubInd_chNewSs] ([submitted_ind_id] ASC,[subsnp_id] ASC,[gty_id] ASC)
\r
96 CREATE NONCLUSTERED INDEX [i_bs] ON [SubInd_chNotOn] ([batch_id] ASC,[subsnp_id] ASC)
\r
98 CREATE NONCLUSTERED INDEX [i_ind_ss] ON [SubInd_chNotOn] ([submitted_ind_id] ASC,[subsnp_id] ASC,[gty_id] ASC)
\r
101 CREATE NONCLUSTERED INDEX [i_bs] ON [SubInd_chPAR] ([batch_id] ASC,[subsnp_id] ASC)
\r
103 CREATE NONCLUSTERED INDEX [i_ind_ss] ON [SubInd_chPAR] ([submitted_ind_id] ASC,[subsnp_id] ASC,[gty_id] ASC)
\r
106 CREATE NONCLUSTERED INDEX [i_bs] ON [SubInd_chUn] ([batch_id] ASC,[subsnp_id] ASC)
\r
108 CREATE NONCLUSTERED INDEX [i_ind_ss] ON [SubInd_chUn] ([submitted_ind_id] ASC,[subsnp_id] ASC,[gty_id] ASC)
\r
111 CREATE NONCLUSTERED INDEX [i_bs] ON [SubInd_chX] ([batch_id] ASC,[subsnp_id] ASC)
\r
113 CREATE NONCLUSTERED INDEX [i_ind_ss] ON [SubInd_chX] ([submitted_ind_id] ASC,[subsnp_id] ASC,[gty_id] ASC)
\r
116 CREATE NONCLUSTERED INDEX [i_bs] ON [SubInd_chY] ([batch_id] ASC,[subsnp_id] ASC)
\r
118 CREATE NONCLUSTERED INDEX [i_ind_ss] ON [SubInd_chY] ([submitted_ind_id] ASC,[subsnp_id] ASC,[gty_id] ASC)
\r
121 CREATE CLUSTERED INDEX [i_b_size] ON [dn_table_rowcount] ([build_id] DESC,[reserved_KB_spaceused] DESC)
\r