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