1 CREATE INDEX ON SubInd_ch1(batch_id, subsnp_id)
3 CREATE INDEX ON SubInd_ch1(submitted_ind_id, subsnp_id, gty_id)
5 CREATE INDEX ON SubInd_ch1(subsnp_id);
6 CREATE INDEX ON SubInd_ch2(subsnp_id);
7 CREATE INDEX ON SubInd_ch3(subsnp_id);
8 CREATE INDEX ON SubInd_ch4(subsnp_id);
9 CREATE INDEX ON SubInd_ch5(subsnp_id);
10 CREATE INDEX ON SubInd_ch6(subsnp_id);
11 CREATE INDEX ON SubInd_ch7(subsnp_id);
12 CREATE INDEX ON SubInd_ch8(subsnp_id);
13 CREATE INDEX ON SubInd_ch9(subsnp_id);
16 CREATE INDEX ON SubInd_ch2(batch_id, subsnp_id)
18 CREATE INDEX ON SubInd_ch2(submitted_ind_id, subsnp_id, gty_id)
22 CREATE INDEX ON SubInd_ch3(batch_id, subsnp_id)
24 CREATE INDEX ON SubInd_ch3(submitted_ind_id, subsnp_id, gty_id)
27 CREATE INDEX ON SubInd_ch4(batch_id, subsnp_id)
29 CREATE INDEX ON SubInd_ch4(submitted_ind_id, subsnp_id, gty_id)
32 CREATE INDEX ON SubInd_ch5(batch_id, subsnp_id)
34 CREATE INDEX ON SubInd_ch5(submitted_ind_id, subsnp_id, gty_id)
37 CREATE INDEX ON SubInd_ch6(batch_id, subsnp_id)
39 CREATE INDEX ON SubInd_ch6(submitted_ind_id, subsnp_id, gty_id)
42 CREATE INDEX ON SubInd_ch7(batch_id, subsnp_id)
44 CREATE INDEX ON SubInd_ch7(submitted_ind_id, subsnp_id, gty_id)
47 CREATE INDEX ON dn_table_rowcount(build_id DESC , reserved_KB_spaceused DESC )