CREATE INDEX ON SubInd_ch10 (batch_id,subsnp_id);
CREATE INDEX ON SubInd_ch10 (submitted_ind_id,subsnp_id,gty_id);
CREATE INDEX ON SubInd_ch11 (batch_id,subsnp_id);
CREATE INDEX ON SubInd_ch11 (submitted_ind_id,subsnp_id,gty_id);
CREATE INDEX ON SubInd_ch12 (batch_id,subsnp_id);
CREATE INDEX ON SubInd_ch12 (submitted_ind_id,subsnp_id,gty_id);
CREATE INDEX ON SubInd_ch13 (batch_id,subsnp_id);
CREATE INDEX ON SubInd_ch13 (submitted_ind_id,subsnp_id,gty_id);
CREATE INDEX ON SubInd_ch14 (batch_id,subsnp_id);
CREATE INDEX ON SubInd_ch14 (submitted_ind_id,subsnp_id,gty_id);
CREATE INDEX ON SubInd_ch15 (batch_id,subsnp_id);
CREATE INDEX ON SubInd_ch15 (submitted_ind_id,subsnp_id,gty_id);
CREATE INDEX ON SubInd_ch16 (batch_id,subsnp_id);
CREATE INDEX ON SubInd_ch16 (submitted_ind_id,subsnp_id,gty_id);
CREATE INDEX ON SubInd_ch17 (batch_id,subsnp_id);
CREATE INDEX ON SubInd_ch17 (submitted_ind_id,subsnp_id,gty_id);
CREATE INDEX ON SubInd_ch18 (batch_id,subsnp_id);
CREATE INDEX ON SubInd_ch18 (submitted_ind_id,subsnp_id,gty_id);
CREATE INDEX ON SubInd_ch19 (batch_id,subsnp_id);
CREATE INDEX ON SubInd_ch19 (submitted_ind_id,subsnp_id,gty_id);
CREATE INDEX ON SubInd_ch20 (batch_id,subsnp_id);
CREATE INDEX ON SubInd_ch20 (submitted_ind_id,subsnp_id,gty_id);
CREATE INDEX ON SubInd_ch21 (batch_id,subsnp_id);
CREATE INDEX ON SubInd_ch21 (submitted_ind_id,subsnp_id,gty_id);
CREATE INDEX ON SubInd_ch22 (batch_id,subsnp_id);
CREATE INDEX ON SubInd_ch22 (submitted_ind_id,subsnp_id,gty_id);
CREATE INDEX ON SubInd_ch8 (batch_id,subsnp_id);
CREATE INDEX ON SubInd_ch8 (submitted_ind_id,subsnp_id,gty_id);
CREATE INDEX ON SubInd_ch9 (batch_id,subsnp_id);
CREATE INDEX ON SubInd_ch9 (submitted_ind_id,subsnp_id,gty_id);
CREATE INDEX ON SubInd_chAltOnly (batch_id,subsnp_id);
CREATE INDEX ON SubInd_chAltOnly (submitted_ind_id,subsnp_id,gty_id);
CREATE INDEX ON SubInd_chMT (batch_id,subsnp_id);
CREATE INDEX ON SubInd_chMT (submitted_ind_id,subsnp_id,gty_id);
CREATE INDEX ON SubInd_chMulti (batch_id,subsnp_id);
CREATE INDEX ON SubInd_chMulti (submitted_ind_id,subsnp_id,gty_id);
CREATE INDEX ON SubInd_chNewSs (batch_id,subsnp_id);
CREATE INDEX ON SubInd_chNewSs (submitted_ind_id,subsnp_id,gty_id);
CREATE INDEX ON SubInd_chNotOn (batch_id,subsnp_id);
CREATE INDEX ON SubInd_chNotOn (submitted_ind_id,subsnp_id,gty_id);
CREATE INDEX ON SubInd_chPAR (batch_id,subsnp_id);
CREATE INDEX ON SubInd_chPAR (submitted_ind_id,subsnp_id,gty_id);
CREATE INDEX ON SubInd_chUn (batch_id,subsnp_id);
CREATE INDEX ON SubInd_chUn (submitted_ind_id,subsnp_id,gty_id);
CREATE INDEX ON SubInd_chX (batch_id,subsnp_id);
CREATE INDEX ON SubInd_chX (submitted_ind_id,subsnp_id,gty_id);
CREATE INDEX ON SubInd_chY (batch_id,subsnp_id);
CREATE INDEX ON SubInd_chY (submitted_ind_id,subsnp_id,gty_id);
CREATE INDEX ON dn_table_rowcount (build_id DESC,reserved_KB_spaceused DESC);
