 COLLECT STATS ON MBR_DB.TGHTCVRGSUBR INDEX(C_COMPANY_ID);
 COLLECT STATS ON MBR_DB.TGHTCVRGSUBR INDEX(I_CONTRACT);
 COLLECT STATS ON MBR_DB.TGHTCVRGSUBR INDEX(I_GROUP_BCBS,I_PACKAGE);
 COLLECT STATS ON MBR_DB.TGHTCVRGSUBR INDEX(I_CONTRACT,I_GROUP_BCBS,D_SUBR_CVRG_EFFECT,D_CVRG_STATUS);
