ALTER TABLE `acc_asset_year` DROP INDEX `ACC_ASSET_YEAR_X`;
ALTER TABLE `acc_asset_year` ADD INDEX `ACC_ASSET_YEAR_X` (`COOP_ID`, `ASSET_DOC`, `ACCOUNT_YEAR`) ;

ALTER TABLE `acc_cal_dp` DROP INDEX `ACC_CAL_DP_X`;
ALTER TABLE `acc_cal_dp` ADD INDEX `ACC_CAL_DP_X` (`COOP_ID`, `ASSET_DOC`, `ACCOUNT_YEAR`, `PERIOD`);

ALTER TABLE `acc_delseries` DROP INDEX `ACC_DELSERIES_X`;
ALTER TABLE `acc_delseries` ADD INDEX `ACC_DELSERIES_X` (`COOP_ID`, `ASSET_DOC`);

ALTER TABLE `acc_detail` DROP INDEX `SYS_C0013281`;
ALTER TABLE `acc_detail` ADD INDEX `SYS_C0013281` (`COOP_ID`, `ACCDETAIL_CODE`, `ACCOUNT_ID`);

ALTER TABLE `acc_dp_rate` DROP INDEX `ACC_DP_RATE_X`;
ALTER TABLE `acc_dp_rate` ADD INDEX `ACC_DP_RATE_X` (`COOP_ID`, `ASSET_DOC`, `SEQ_NO`);

ALTER TABLE `acc_dp_year` DROP INDEX `ACC_DP_YEAR_X`;
ALTER TABLE `acc_dp_year` ADD INDEX `ACC_DP_YEAR_X` (`COOP_ID`, `DP_YEAR`);

ALTER TABLE `acc_post_pay` DROP INDEX `SYS_C0013284`;
ALTER TABLE `acc_post_pay` ADD INDEX `SYS_C0013284` (`COOP_ID`, `SEQ_NO`);

ALTER TABLE `acc_slip_drcr` DROP INDEX `SYS_C0013290`;
ALTER TABLE `acc_slip_drcr` ADD INDEX `SYS_C0013290` (`COOP_ID`, `JOURNAL_DATE`, `L_SEQ_NO`, `ACC_BOOK_TYPE_ID`, `ACCOUNT_NATURE`);

ALTER TABLE `acc_splitmoreactivity` DROP INDEX `PK_ACC_SPLITMOREACTIVITY`;
ALTER TABLE `acc_splitmoreactivity` ADD INDEX `PK_ACC_SPLITMOREACTIVITY` (`COOP_ID`, `ACC_YEAR`, `ACC_PERIOD`, `ACCOUNT_ID`);

ALTER TABLE `acc_temp_for_accda` DROP INDEX `SYS_C0013298`;
ALTER TABLE `acc_temp_for_accda` ADD INDEX `SYS_C0013298` (`ACC_DATE`, `SEQ_NO`);

ALTER TABLE `accaccountbegin` DROP INDEX `SYS_C0013132`;
ALTER TABLE `accaccountbegin` ADD INDEX `SYS_C0013132` (`COOP_ID`, `ACCOUNT_ID`, `ACCOUNT_YEAR`, `PERIOD`);

ALTER TABLE `accaccountyear` DROP INDEX `ACCACCOUNTYEAR_X`;
ALTER TABLE `accaccountyear` ADD UNIQUE `ACCACCOUNTYEAR_X` (`COOP_ID`, `ACCOUNT_YEAR`);

ALTER TABLE `accadjust_ledger` DROP INDEX `SYS_C0013139`;
ALTER TABLE `accadjust_ledger` ADD INDEX `SYS_C0013139` (`COOP_ID`, `ACCOUNT_YEAR`, `PERIOD`);

ALTER TABLE `accastimate_dc` DROP INDEX `SYS_C0013144`;
ALTER TABLE `accastimate_dc` ADD INDEX `SYS_C0013144` (`COOP_ID`, `ACC_YEAR`, `ACC_CODE_ASTIMATE`, `MONTH`) ;

ALTER TABLE `accastimate_ucf_ty` DROP INDEX `XPKACCASTIMATE_UCF_TY`;
ALTER TABLE `accastimate_ucf_ty` ADD INDEX `XPKACCASTIMATE_UCF_TY` (`COOP_ID`) ;

ALTER TABLE `accastimate_ucf_ty` DROP INDEX `ACCASTIMATE_UCF_TY_X`;
ALTER TABLE `accastimate_ucf_ty` ADD INDEX `ACCASTIMATE_UCF_TY_X` (`ACC_CODE_ASTIMATE`);

ALTER TABLE `accbudget` DROP INDEX `ACCBUDGET_X`;
ALTER TABLE `accbudget` ADD INDEX `ACCBUDGET_X` (`COOP_ID`, `ACCOUNT_YEAR`, `SORT_SEQ`, `ACCRCVPAY`) ;

ALTER TABLE `accbudget_group` DROP INDEX `ACCBUDGET_GROUP_X`;
ALTER TABLE `accbudget_group` ADD INDEX `ACCBUDGET_GROUP_X` (`ACCBUDGETGROUP_TYP`, `COOP_ID`, `ACCRCVPAY`);

ALTER TABLE `acccntcode` DROP INDEX `PK_SYS0000212`;
ALTER TABLE `acccntcode` ADD INDEX `PK_SYS0000212` (`COOP_ID`, `CNT_CODE`);

ALTER TABLE `acccntcoop` DROP INDEX `ACCCNTCOOP_X`;
ALTER TABLE `acccntcoop` ADD INDEX `ACCCNTCOOP_X` (`COOP_ID`, `COOP_REGISTERED_NO`);

ALTER TABLE `acccntmoneysheet` DROP INDEX `PK_SYS00001212`;
ALTER TABLE `acccntmoneysheet` ADD INDEX `PK_SYS00001212` (`COOP_ID`, `ACCOUNT_YEAR`, `PERIOD`, `SEQ_NO`, `CNT_SHORT_AMT`);

ALTER TABLE `accconstant` DROP INDEX `ACCCONSTANT_X`;
ALTER TABLE `accconstant` ADD INDEX `ACCCONSTANT_X` (`COOP_ID`, `COOP_REGISTERED_NO`);

ALTER TABLE `accjournalcrime` DROP INDEX `SYS_C0013181`;
ALTER TABLE `accjournalcrime` ADD INDEX `SYS_C0013181` (`COOP_ID`);

ALTER TABLE `accjournalcure` DROP INDEX `SYS_C0013189`;
ALTER TABLE `accjournalcure` ADD INDEX `SYS_C0013189` (`COOP_ID`, `ACC_BOOK_TYPE`, `JOURNAL_DATE`, `ACCOUNT_NATURE`, `SEQUENCE_NO`, `ORDER_NO`, `ACCOUNT_ID`);

ALTER TABLE `accleddetailgroup` DROP INDEX `SYS_C0013197`;
ALTER TABLE `accleddetailgroup` ADD INDEX `SYS_C0013197` (`COOP_ID`, `ACCLEDGROUP_TYP`, `ACCOUNT_ID`);

ALTER TABLE `accledger_detail` DROP INDEX `SYS_C0013206`;
ALTER TABLE `accledger_detail` ADD INDEX `SYS_C0013206` (`COOP_ID`, `JOURNAL_DATE`, `ACCOUNT_NATURE`, `SEQ_NO`, `ORDER_NO`, `ACCOUNT_ID`, `VOUCHER_NO`);

ALTER TABLE `accperiod` DROP INDEX `ACCPERIOD_X`;
ALTER TABLE `accperiod` ADD INDEX `ACCPERIOD_X` (`COOP_ID`, `ACCOUNT_YEAR`, `PERIOD`);

ALTER TABLE `accperiodbudget` DROP INDEX `SYS_C0013218`;
ALTER TABLE `accperiodbudget` ADD INDEX `SYS_C0013218` (`ACCOUNT_YEAR`, `PERIOD`, `ACCOUNT_ID`, `COOP_ID`);

ALTER TABLE `accperiodsumbudget` DROP INDEX `ACCPERIODSUMBUDGET_X`;
ALTER TABLE `accperiodsumbudget` ADD INDEX `ACCPERIODSUMBUDGET_X` (`COOP_ID`, `ACCOUNT_YEAR`, `PERIOD`, `ACCRCVPAY`, `SEQ_NO`);

ALTER TABLE `accsheetmoneydet` DROP INDEX `ACCSHEETMONEYDET_X`;
ALTER TABLE `accsheetmoneydet` ADD INDEX `ACCSHEETMONEYDET_X` (`MONEYSHEET_CODE`, `MONEYSHEET_SEQ`, `COOP_ID`);

ALTER TABLE `accsheetmoneyhead` DROP INDEX `ACCSHEETMONEYHEAD_X`;
ALTER TABLE `accsheetmoneyhead` ADD INDEX `ACCSHEETMONEYHEAD_X` (`COOP_ID`, `MONEYSHEET_CODE`);

ALTER TABLE `accsheetmoneytype` DROP INDEX `ACCSHEETMONEYTYPE_X`;
ALTER TABLE `accsheetmoneytype` ADD INDEX `ACCSHEETMONEYTYPE_X` (`COOP_ID`, `DATA_TYPE_DESCRIPT`);

ALTER TABLE `accsumledger_bk` DROP INDEX `SYS_C0013251`;
ALTER TABLE `accsumledger_bk` ADD INDEX `SYS_C0013251` (`COOP_ID`, `ACCOUNT_YEAR`, `PERIOD`, `ACCOUNT_ID`);

ALTER TABLE `accsumledgerdate` DROP INDEX `SYS_C0013236`;
ALTER TABLE `accsumledgerdate` ADD INDEX `SYS_C0013236` (`COOP_ID`);

ALTER TABLE `accsumledgeryear` DROP INDEX `SYS_C0013246`;
ALTER TABLE `accsumledgeryear` ADD INDEX `SYS_C0013246` (`COOP_ID`, `ACCOUNT_YEAR`, `PERIOD`, `ACCOUNT_ID`);

ALTER TABLE `accucfacctype` DROP INDEX `ACCUCFACCTYPE_X`;
ALTER TABLE `accucfacctype` ADD INDEX `ACCUCFACCTYPE_X` (`ACCOUNT_TYPE_ID`);

ALTER TABLE `accucfbooktype` DROP INDEX `ACCUCFBOOKTYPE_X`;
ALTER TABLE `accucfbooktype`  ADD INDEX `ACCUCFBOOKTYPE_X` (`COOP_ID`, `ACC_BOOK_TYPE_ID`);

ALTER TABLE `accucfcashflow` DROP INDEX `SYS_C0057269`;
ALTER TABLE `accucfcashflow` ADD INDEX `SYS_C0057269` (`COOP_ID`, `SEQ_NO`);

ALTER TABLE `accucfgroup` DROP INDEX `ACCUCFGROUP_X`;
ALTER TABLE `accucfgroup` ADD INDEX `ACCUCFGROUP_X` (`COOP_ID`, `ACCOUNT_GROUP_ID`);

ALTER TABLE `accworksheet` DROP INDEX `SYS_C0013267`;
ALTER TABLE `accworksheet` ADD INDEX `SYS_C0013267` (`COOP_ID`, `ACCOUNT_ID`, `ACCOUNT_YEAR`);

ALTER TABLE `amapplockeditem` DROP INDEX `SYS_C0013344`;
ALTER TABLE `amapplockeditem` ADD INDEX `SYS_C0013344` (`APPLICATION`, `TERM_ID`, `WINDOW_ID`, `LOCKED_ITEM`);

ALTER TABLE `amappprocess` DROP INDEX `SYS_C0013347`;
ALTER TABLE `amappprocess` ADD INDEX `SYS_C0013347` (`APPLICATION`, `PROCESS_ID`);

ALTER TABLE `amappusages` DROP INDEX `SYS_C0013354`;
ALTER TABLE `amappusages` ADD INDEX `SYS_C0013354` (`APPLICATION`, `TERM_ID`, `WINDOW_ID`);

ALTER TABLE `amappusageslog` DROP INDEX `SYS_C0013360`;
ALTER TABLE `amappusageslog` ADD INDEX `SYS_C0013360` (`LOGDATE`, `SEQ_NO`);

ALTER TABLE `amlaunchitem` DROP INDEX `SYS_C0013369`;
ALTER TABLE `amlaunchitem` ADD INDEX `SYS_C0013369` (`APPLICATION`, `LAUANCH_ITEM`);

ALTER TABLE `amprocessschedule` DROP INDEX `SYS_C0013374`;
ALTER TABLE `amprocessschedule` ADD INDEX `SYS_C0013374` (`MONTH`, `DAY`, `APPLICATION`, `PROCESS_ID`);

ALTER TABLE `amprocessstatus` DROP INDEX `SYS_C0013378`;
ALTER TABLE `amprocessstatus` ADD INDEX `SYS_C0013378` (`APPLICATION`, `PROCESS_ID`);

ALTER TABLE `amsecapvlevel` DROP INDEX `AMSECAPVLEVEL_X`;
ALTER TABLE `amsecapvlevel` ADD INDEX `AMSECAPVLEVEL_X` (`APVLEVEL_ID`);

ALTER TABLE `amsecreportpermiss` DROP INDEX `SYS_C009689`;
ALTER TABLE `amsecreportpermiss` ADD INDEX `SYS_C009689` (`COOP_ID`, `USER_NAME`, `GROUP_ID`, `REPORT_ID`);

ALTER TABLE `amsecwins` DROP INDEX `SYS_AMSECWINS`;
ALTER TABLE `amsecwins` ADD INDEX `SYS_AMSECWINS` (`WINDOW_ID`, `APPLICATION`);

ALTER TABLE `amterminal` DROP INDEX `SYS_C0013422`;
ALTER TABLE `amterminal` ADD INDEX `SYS_C0013422` (`TERM_ID`);

ALTER TABLE `asnchildlists` DROP INDEX `SYS_C0049867`;
ALTER TABLE `asnchildlists` ADD INDEX `SYS_C0049867` (`MEMBER_NO`, `CHILD_NAME`);

ALTER TABLE `asnucfpayktdead` DROP INDEX `ASNUCFPAYKTDEAD_X`;
ALTER TABLE `asnucfpayktdead` ADD INDEX `ASNUCFPAYKTDEAD_X` (`SEQ_NO`);

ALTER TABLE `asnucfpaystatus` DROP INDEX `SYS_C0021234`;
ALTER TABLE `asnucfpaystatus` ADD INDEX `SYS_C0021234` (`PAY_CODE`);

ALTER TABLE `asnucfsubdamagetype` DROP INDEX `SYS_C0055524`;
ALTER TABLE `asnucfsubdamagetype` ADD INDEX `SYS_C0055524` (`SUBDAMAGETYPE_CODE`);

ALTER TABLE `cmapplreportdet` DROP INDEX `XIF453CMAPPLREPORTDET`;
ALTER TABLE `cmapplreportdet` ADD INDEX `XIF453CMAPPLREPORTDET` (`GROUP_ID`, `APPLICATION`);

ALTER TABLE `cmapvcanceldet` DROP INDEX `XIF444CMAPVCANCELDET`;
ALTER TABLE `cmapvcanceldet` ADD INDEX `XIF444CMAPVCANCELDET` (`APVCCL_DOCNO`);

ALTER TABLE `cmclsdayloanbal_tks` DROP INDEX `CMCLSDAYLOANBAL_XS`;
ALTER TABLE `cmclsdayloanbal_tks` ADD INDEX `CMCLSDAYLOANBAL_XS` (`CLOSE_DATE`, `LOANTYPE_CODE`, `CONTRACT_TYPE`);

ALTER TABLE `cmcoopmaster` DROP INDEX `XPKCMCOOPMASTER`;
ALTER TABLE `cmcoopmaster` ADD INDEX `XPKCMCOOPMASTER` (`COOP_ID`);

ALTER TABLE `cmproclog` DROP INDEX `XPKCMPROCLOG`;
ALTER TABLE `cmproclog` ADD INDEX `XPKCMPROCLOG` (`COOP_ID`, `APPLICATION`, `PROC_DATE`, `SEQ_NO`);

ALTER TABLE `cmproclogdetail` DROP INDEX `XPKCMPROCLOGDETAIL`;
ALTER TABLE `cmproclogdetail` ADD INDEX `XPKCMPROCLOGDETAIL` (`COOP_ID`, `APPLICATION`, `PROC_DATE`, `SEQ_NO`, `SUBSEQ_NO`);

ALTER TABLE `cmreportmaping` DROP INDEX `SYS_C0013753`;
ALTER TABLE `cmreportmaping` ADD INDEX `SYS_C0013753` (`SYSTEM_CODE`);

ALTER TABLE `cmroundmoney` DROP INDEX `XPKCMROUNDMONEY`;
ALTER TABLE `cmroundmoney` ADD INDEX `XPKCMROUNDMONEY` (`COOP_ID`, `APPLGROUP_CODE`, `FUNCTION_CODE`);

ALTER TABLE `cmshrlondoccontrol_tks` DROP INDEX `CMSHRLONDOCCONTROL_X2`;
ALTER TABLE `cmshrlondoccontrol_tks` ADD INDEX `CMSHRLONDOCCONTROL_X2` (`DOCUMENT_CODE`);

ALTER TABLE `cmshrlonslip` DROP INDEX `CMSHRLONSLIP`;
ALTER TABLE `cmshrlonslip` ADD INDEX `CMSHRLONSLIP` (`SLIP_NO`, `BRANCH_ID`);

ALTER TABLE `cmucfapvcclcause` DROP INDEX `XIF446CMUCFAPVCCLCAUSE`;
ALTER TABLE `cmucfapvcclcause` ADD INDEX `XIF446CMUCFAPVCCLCAUSE` (`APVCCLCAUSE_CODE`);

ALTER TABLE `cmucftofromaccid` DROP INDEX `XPKCMUCFTOFROMACCID`;
ALTER TABLE `cmucftofromaccid` ADD INDEX `XPKCMUCFTOFROMACCID` (`COOP_ID`, `APPLGROUP_CODE`, `SLIPTYPE_CODE`, `MONEYTYPE_CODE`, `ACCOUNT_ID`);

ALTER TABLE `cmucftofromsystem` DROP INDEX `XPKCMUCFTOFROMSYSTEM`;
ALTER TABLE `cmucftofromsystem` ADD INDEX `XPKCMUCFTOFROMSYSTEM` (`SYSTEM_CODE`);

ALTER TABLE `cmusersactivities` DROP INDEX `XAK1CMUSERSACTIVITIES`;
ALTER TABLE `cmusersactivities` ADD INDEX `XAK1CMUSERSACTIVITIES` (`USER_NAME`);

ALTER TABLE `dpaudit` DROP INDEX `SYS_C0048733`;
ALTER TABLE `dpaudit` ADD INDEX `SYS_C0048733` (`COOP_ID`, `DOCNO`);

ALTER TABLE `dpchequeprint` DROP INDEX `SYS_C0048741`;
ALTER TABLE `dpchequeprint` ADD INDEX `SYS_C0048741` (`COOP_ID`, `PRINT_DATE`);

ALTER TABLE `dpcloseaccomonth` DROP INDEX `SYS_C0048753`;
ALTER TABLE `dpcloseaccomonth` ADD INDEX `SYS_C0048753` (`COOP_ID`, `ACCOUNT_YEAR`, `CLOSEMONTH_NO`, `DEPTACCOUNT_NO`);

ALTER TABLE `dpclosedprocstatus` DROP INDEX `SYS_C0048761`;
ALTER TABLE `dpclosedprocstatus` ADD INDEX `SYS_C0048761` (`COOP_ID`, `PROC_DATE`);

ALTER TABLE `dpclosemprocstatus` DROP INDEX `SYS_C0048765`;
ALTER TABLE `dpclosemprocstatus` ADD INDEX `SYS_C0048765` (`COOP_ID`, `PROC_YEAR`, `PROC_MONTH`);

ALTER TABLE `dpclosescoday` DROP INDEX `SYS_C0048769`;
ALTER TABLE `dpclosescoday` ADD INDEX `SYS_C0048769` (`COOP_ID`, `CLOSE_DATE`, `DEPTTYPE_CODE`);

ALTER TABLE `dpclosescomonth` DROP INDEX `SYS_C0048774`;
ALTER TABLE `dpclosescomonth` ADD INDEX `SYS_C0048774` (`COOP_ID`, `ACCOUNT_YEAR`, `CLOSEMONTH_NO`, `DEPTTYPE_CODE`);

ALTER TABLE `dpclosescoyear` DROP INDEX `SYS_C0048778`;
ALTER TABLE `dpclosescoyear` ADD INDEX `SYS_C0048778` (`COOP_ID`, `ACCOUNT_YEAR`, `DEPTTYPE_CODE`);

ALTER TABLE `dpcloseyprocstatus` DROP INDEX `SYS_C0048781`;
ALTER TABLE `dpcloseyprocstatus` ADD INDEX `SYS_C0048781` (`COOP_ID`, `PROC_YEAR`);

ALTER TABLE `dpcodeposit` DROP INDEX `SYS_C0048786`;
ALTER TABLE `dpcodeposit` ADD INDEX `SYS_C0048786` (`COOP_ID`, `DEPTACCOUNT_NO`, `SEQ_NO`, `REF_NO`);

ALTER TABLE `dpdeptaccintrate` DROP INDEX `SYS_C0048790`;
ALTER TABLE `dpdeptaccintrate` ADD INDEX `SYS_C0048790` (`COOP_ID`, `DEPTACCOUNT_NO`, `EFFECTIVE_DATE`);

ALTER TABLE `dpdeptadvancedw` DROP INDEX `SYS_C0048799`;
ALTER TABLE `dpdeptadvancedw` ADD INDEX `SYS_C0048799` (`COOP_ID`, `DW_DATE`, `DEPTACCOUNT_NO`, `SEQ_NO`);

ALTER TABLE `dpdeptaudithistory` DROP INDEX `SYS_C0048804`;
ALTER TABLE `dpdeptaudithistory` ADD INDEX `SYS_C0048804` (`COOP_ID`, `DOCNO`, `COL_ID`, `SEQ_NO`);

ALTER TABLE `dpdeptbookhis` DROP INDEX `SYS_C0048809`;
ALTER TABLE `dpdeptbookhis` ADD INDEX `SYS_C0048809` (`COOP_ID`, `BOOK_TYPE`, `BOOK_NO`, `BOOK_GRP`);

ALTER TABLE `dpdeptfutureintrpt` DROP INDEX `SYS_C0048816`;
ALTER TABLE `dpdeptfutureintrpt` ADD UNIQUE `SYS_C0048816` (`COOP_ID`, `DEPTACCOUNT_NO`, `DEPTTYPE_CODE`,`INT_YEAR`);

ALTER TABLE `dpdeptbookhisauto` DROP INDEX `SYS_DPDEPTBOOKHISAUTO`;
ALTER TABLE `dpdeptbookhisauto` ADD INDEX `SYS_DPDEPTBOOKHISAUTO` (`RQUID`, `ACCTNUM`, `DATE_WORK`);

ALTER TABLE `dpdeptgarantee` DROP INDEX `SYS_C0048820`;
ALTER TABLE `dpdeptgarantee` ADD INDEX `SYS_C0048820` (`COOP_ID`, `DEPTACCOUNT_NO`, `SEQ_NO`);

ALTER TABLE `dpdeptgetshare` DROP INDEX `SYS_C0048823`;
ALTER TABLE `dpdeptgetshare` ADD INDEX `SYS_C0048823` (`MEMCOOP_ID`, `MEMBER_NO`);

ALTER TABLE `dpdeptintestimate` DROP INDEX `SYS_C0048826`;
ALTER TABLE `dpdeptintestimate` ADD INDEX `SYS_C0048826` (`COOP_ID`, `DEPTACCOUNT_NO`);

ALTER TABLE `dpdeptintpaydate` DROP INDEX `SYS_C0048838`;
ALTER TABLE `dpdeptintpaydate` ADD INDEX `SYS_C0048838` (`COOP_ID`, `DEPTTYPE_CODE`, `EFFECTIVE_DATE`, `SEQ_NO`, `MINBAL_TYPE`, `SEQNO`);

ALTER TABLE `dpdeptmasdue` DROP INDEX `SYS_C0017146`;
ALTER TABLE `dpdeptmasdue` ADD INDEX `SYS_C0017146` (`COOP_ID`, `DEPTACCOUNT_NO`, `SEQ_NO`);

ALTER TABLE `dpdeptminbalint` DROP INDEX `SYS_C0048870`;
ALTER TABLE `dpdeptminbalint` ADD INDEX `SYS_C0048870` (`COOP_ID`, `DEPTTYPE_CODE`, `MINBAL_TYPE`, `EFFECTIVE_DATE`, `SEQ_NO`);

ALTER TABLE `dpdeptmonthly` DROP INDEX `SYS_C0014024`;
ALTER TABLE `dpdeptmonthly` ADD INDEX `SYS_C0014024` (`COOP_ID`, `DEPTACCOUNT_NO`, `MEMCOOP_ID`, `MEMBER_NO`);

ALTER TABLE `dpdeptmonthlycut` DROP INDEX `SYS_C0014029`;
ALTER TABLE `dpdeptmonthlycut` ADD INDEX `SYS_C0014029` (`MEMCOOP_ID`, `MEMBER_NO`, `YEARMONTH`, `SEQ_NO`);

ALTER TABLE `dpdeptmonthlydet` DROP INDEX `SYS_C0014034`;
ALTER TABLE `dpdeptmonthlydet` ADD INDEX `SYS_C0014034` (`COOP_ID`, `DEPTACCOUNT_NO`, `MEMCOOP_ID`, `MEMBER_NO`);

ALTER TABLE `dpdeptmthcut` DROP INDEX `SYS_C0048892`;
ALTER TABLE `dpdeptmthcut` ADD INDEX `SYS_C0048892` (`COOP_ID`, `YEARMONTH_CUT`, `DEPTACCOUNT_NO`, `SEQ_NO`);

ALTER TABLE `dpdeptprintchq` DROP INDEX `SYS_C0048898`;
ALTER TABLE `dpdeptprintchq` ADD INDEX `SYS_C0048898` (`COOP_ID`, `OPERATE_DATE`);

ALTER TABLE `dpdeptprncfixed` DROP INDEX `IDX_FIXPRNCDATE`;
ALTER TABLE `dpdeptprncfixed` ADD INDEX `IDX_FIXPRNCDATE` (`PRNC_DATE`);
ALTER TABLE `dpdeptprncfixed` DROP INDEX `IDX_FIXPRNCDUEDATE`;
ALTER TABLE `dpdeptprncfixed` ADD INDEX `IDX_FIXPRNCDUEDATE` (`PRNCDUE_DATE`);

ALTER TABLE `dpdeptreqsequest` DROP INDEX `SYS_C0011593`;
ALTER TABLE `dpdeptreqsequest` ADD INDEX `SYS_C0011593` (`COOP_ID`, `DEPTACCOUNT_NO`, `SEQUESTDOC_NO`);

ALTER TABLE `dpdeptreturncheck` DROP INDEX `SYS_C0048915`;
ALTER TABLE `dpdeptreturncheck` ADD INDEX `SYS_C0048915` (`COOP_ID`, `CHECK_NO`, `BANK_CODE`, `BANKBRANCH_CODE`, `SEQ_NO`);

ALTER TABLE `dpdeptslip` DROP INDEX `SYS_C0048923`;
ALTER TABLE `dpdeptslip` ADD INDEX `SYS_C0048923` (`COOP_ID`, `DEPTSLIP_NO`);
ALTER TABLE `dpdeptslip` DROP INDEX `IDX_SLIPRECPAY`;
ALTER TABLE `dpdeptslip` ADD INDEX `IDX_SLIPRECPAY` (`RECPPAYTYPE_CODE`);
ALTER TABLE `dpdeptslip` DROP INDEX `IDX_SLIPDEPTTYPE`;
ALTER TABLE `dpdeptslip` ADD INDEX `IDX_SLIPDEPTTYPE` (`DEPTTYPE_CODE`);
ALTER TABLE `dpdeptslip` DROP INDEX `IDX_SLIPENTRY_DATE`;
ALTER TABLE `dpdeptslip` ADD INDEX `IDX_SLIPENTRY_DATE` (`ENTRY_DATE`);
ALTER TABLE `dpdeptslip` DROP INDEX `IDX_SLIPITEMTYPE`;
ALTER TABLE `dpdeptslip` ADD INDEX `IDX_SLIPITEMTYPE` (`DEPTITEMTYPE_CODE`);

ALTER TABLE `dpdeptslipcheque` DROP INDEX `SYS_C0048929`;
ALTER TABLE `dpdeptslipcheque` ADD INDEX `SYS_C0048929` (`COOP_ID`, `DEPTSLIP_NO`, `CHEQUE_NO`, `BANK_CODE`, `BANKBRANCH_CODE`);

ALTER TABLE `dpdeptslipdet` DROP INDEX `SYS_C0048937`;
ALTER TABLE `dpdeptslipdet` ADD INDEX `SYS_C0048937` (`COOP_ID`, `DEPTSLIP_NO`, `PRNC_NO`);

ALTER TABLE `dpdeptstatement` DROP INDEX `IDX_DEPTSTATEMENT_DEPTITEMTYPE`;
ALTER TABLE `dpdeptstatement` ADD INDEX `IDX_DEPTSTATEMENT_DEPTITEMTYPE` (`DEPTITEMTYPE_CODE`);
ALTER TABLE `dpdeptstatement` DROP INDEX `IDX_STMENTRYDATE`;
ALTER TABLE `dpdeptstatement` ADD INDEX `IDX_STMENTRYDATE` (`ENTRY_DATE`);
ALTER TABLE `dpdeptstatement` DROP INDEX `IDX_STMDATE`;
ALTER TABLE `dpdeptstatement` ADD INDEX `IDX_STMDATE` (`OPERATE_DATE`);
ALTER TABLE `dpdeptstatement` DROP INDEX `SYS_C0048943`;
ALTER TABLE `dpdeptstatement` ADD INDEX `SYS_C0048943` (`COOP_ID`, `DEPTACCOUNT_NO`, `SEQ_NO`);

ALTER TABLE `dpdepttran` DROP INDEX `SYS_C0048961`;
ALTER TABLE `dpdepttran` ADD INDEX `SYS_C0048961` (`COOP_ID`, `DEPTACCOUNT_NO`, `MEMCOOP_ID`, `MEMBER_NO`, `SYSTEM_CODE`, `TRAN_YEAR`, `TRAN_DATE`, `SEQ_NO`);

ALTER TABLE `dpdepttranint` DROP INDEX `DPDEPTTRANINT_X`;
ALTER TABLE `dpdepttranint` ADD INDEX `DPDEPTTRANINT_X` (`COOP_ID`, `DEPTACCOUNT_NO`, `SEQ_NO`, `ENTRY_DATE`);

ALTER TABLE `dpdepttypebalday` DROP INDEX `SYS_C0048975`;
ALTER TABLE `dpdepttypebalday` ADD INDEX `SYS_C0048975` (`COOP_ID`, `DEPTTYPE_CODE`, `ENTRY_DATE`);

ALTER TABLE `dpexamintratechg` DROP INDEX `SYS_C0048979`;
ALTER TABLE `dpexamintratechg` ADD INDEX `SYS_C0048979` (`COOP_ID`, `DEPTACCOUNT_NO`);

ALTER TABLE `dpinttaxadvance` DROP INDEX `SYS_C0014151`;
ALTER TABLE `dpinttaxadvance` ADD INDEX `SYS_C0014151` (`COOP_ID`, `DEPTACCOUNT_NO`, `SEQ_NO`, `PRNC_DUEDATE`);

ALTER TABLE `dpinttaxstatement` DROP INDEX `SYS_C0048991`;
ALTER TABLE `dpinttaxstatement` ADD INDEX `SYS_C0048991` (`COOP_ID`, `SEQ_NO`, `PRNC_DUEDATE`, `DEPTACCOUNT_NO`);

ALTER TABLE `dpnrba` DROP INDEX `SYS_C0049004`;
ALTER TABLE `dpnrba` ADD INDEX `SYS_C0049004` (`COOP_ID`, `DEPTACCOUNT_NO`, `ENTRY_DATE`);

ALTER TABLE `dppreinterate` DROP INDEX `SYS_C0049009`;
ALTER TABLE `dppreinterate` ADD UNIQUE `SYS_C0049009` (`COOP_ID`, `DEPTTYPE_CODE`, `PRESEQ_NO`, `EFFECTIVE_DATE`, `DEPT_STEP`);

ALTER TABLE `dppreinterate` DROP INDEX `SYS_C0049009`;
ALTER TABLE `dppreinterate` ADD UNIQUE `SYS_C0049009` (`COOP_ID`, `DEPTTYPE_CODE`, `PRESEQ_NO`, `EFFECTIVE_DATE`, `DEPT_STEP`);

ALTER TABLE `dpreqchgmonthkeep` DROP INDEX `SYS_C0014182`;
ALTER TABLE `dpreqchgmonthkeep` ADD INDEX `SYS_C0014182` (`COOP_ID`, `DEPTACCOUNT_NO`, `DEPTREQUEST_DOCNO`);

ALTER TABLE `dpreqchgmonthkeepdet` DROP INDEX `SYS_C0014187`;
ALTER TABLE `dpreqchgmonthkeepdet` ADD INDEX `SYS_C0014187` (`COOP_ID`, `DEPTACCOUNT_NO`, `DEPTREQUEST_DOCNO`, `SEQ_NO`);

ALTER TABLE `dpreqcodeposit` DROP INDEX `SYS_C0014196`;
ALTER TABLE `dpreqcodeposit` ADD INDEX `SYS_C0014196` (`COOP_ID`, `DEPTREQUEST_DOCNO`, `SEQ_NO`, `REF_ID`);

ALTER TABLE `dpreqdeposit` DROP INDEX `SYS_C0049020`;
ALTER TABLE `dpreqdeposit` ADD INDEX `SYS_C0049020` (`COOP_ID`, `DEPTREQUEST_DOCNO`);

ALTER TABLE `dpreqsignatur` DROP INDEX `SYS_C0049024`;
ALTER TABLE `dpreqsignatur` ADD INDEX `SYS_C0049024` (`COOP_ID`, `DEPTREQUEST_DOCNO`, `SEQ_NO`);

ALTER TABLE `dpsignatur` DROP INDEX `SYS_C0049028`;
ALTER TABLE `dpsignatur` ADD INDEX `SYS_C0049028` (`COOP_ID`, `DEPTACCOUNT_NO`, `SEQ_NO`);

ALTER TABLE `dpstmclr_detial` DROP INDEX `SYS_C0049031`;
ALTER TABLE `dpstmclr_detial` ADD INDEX `SYS_C0049031` (`COOP_ID`, `CLEAR_NO`, `CLEAR_SEQ`);

ALTER TABLE `dpstmclr_master` DROP INDEX `SYS_C0049034`;
ALTER TABLE `dpstmclr_master` ADD INDEX `SYS_C0049034` (`COOP_ID`, `CLEAR_NO`);

ALTER TABLE `dpstmclr_person` DROP INDEX `SYS_C0049038`;
ALTER TABLE `dpstmclr_person` ADD INDEX `SYS_C0049038` (`COOP_ID`, `CLEAR_NO`, `SEQ_NO`);

ALTER TABLE `dptaxpayyear` DROP INDEX `SYS_C0014234`;
ALTER TABLE `dptaxpayyear` ADD INDEX `SYS_C0014234` (`COOP_ID`, `YEAR_PAY`, `MEMCOOP_ID`, `MEMBER_NO`);

ALTER TABLE `dpucfcancelchq` DROP INDEX `SYS_C0049068`;
ALTER TABLE `dpucfcancelchq` ADD INDEX `SYS_C0049068` (`CANCEL_ID`);

ALTER TABLE `dpucfdeptgroup` DROP INDEX `SYS_C0049073`;
ALTER TABLE `dpucfdeptgroup` ADD INDEX `SYS_C0049073` (`COOP_ID`, `DEPTGROUP_CODE`, `DEPTTYPE_GROUP`);

ALTER TABLE `dpucffeechqbc` DROP INDEX `SYS_C0049078`;
ALTER TABLE `dpucffeechqbc` ADD INDEX `SYS_C0049078` (`COOP_ID`, `BANK_CODE`);

ALTER TABLE `dpucfmoneychgrate` DROP INDEX `SYS_C0049080`;
ALTER TABLE `dpucfmoneychgrate` ADD INDEX `SYS_C0049080` (`COOP_ID`, `COUNTRY_CODE`);

ALTER TABLE `dpucfnobookpermiss` DROP INDEX `SYS_C0049083`;
ALTER TABLE `dpucfnobookpermiss` ADD INDEX `SYS_C0049083` (`COOP_ID`, `USER_NAME`);

ALTER TABLE `dpucfsequestreson` DROP INDEX `SYS_C0049087`;
ALTER TABLE `dpucfsequestreson` ADD INDEX `SYS_C0049087` (`COOP_ID`, `SEQUEST_CODE`) ;

ALTER TABLE `dpucftofdept` DROP INDEX `SYS_C1048865`;
ALTER TABLE `dpucftofdept` ADD INDEX `SYS_C1048865` (`COOP_ID`, `DEPTTYPE_GROUP`);

ALTER TABLE `dpudffeechqbc` DROP INDEX `SYS_C0049099`;
ALTER TABLE `dpudffeechqbc` ADD INDEX `SYS_C0049099` (`COOP_ID`, `BANK_CODE`);

ALTER TABLE `finbankaccount` DROP INDEX `SYS_C0049107`;
ALTER TABLE `finbankaccount` ADD INDEX `SYS_C0049107` (`COOP_ID`, `ACCOUNT_NO`, `BANK_CODE`, `BANKBRANCH_CODE`);

ALTER TABLE `finbankstatement` DROP INDEX `SYS_C0049113`;
ALTER TABLE `finbankstatement` ADD INDEX `SYS_C0049113` (`COOP_ID`, `ACCOUNT_NO`, `BANK_CODE`, `BANKBRANCH_CODE`, `SEQ_NO`);

ALTER TABLE `finbridgechq` DROP INDEX `INDEX_SLIP_NO`;
ALTER TABLE `finbridgechq` ADD INDEX `INDEX_SLIP_NO` (`SLIP_NO`);

ALTER TABLE `fincash_control` DROP INDEX `SYS_C0049121`;
ALTER TABLE `fincash_control` ADD INDEX `SYS_C0049121` (`COOP_ID`, `CASH_SLIPNO`);

ALTER TABLE `fincheckretrieve` DROP INDEX `SYS_C0049126`;
ALTER TABLE `fincheckretrieve` ADD INDEX `SYS_C0049126` (`COOP_ID`, `CHECK_NO`, `BANK_CODE`, `BANKBRANCH_CODE`, `SEQ_NO`);

ALTER TABLE `fincheque_insafe` DROP INDEX `SYS_C0049142`;
ALTER TABLE `fincheque_insafe` ADD INDEX `SYS_C0049142` (`COOP_ID`, `OPERATE_DATE`, `INSAFE_SEQ`, `CHECK_NO`, `SEQ_NO`);

ALTER TABLE `finchequemas` DROP INDEX `SYS_C0049131`;
ALTER TABLE `finchequemas` ADD INDEX `SYS_C0049131` (`COOP_ID`, `CHEQUEBOOK_NO`, `BANK_CODE`, `BANK_BRANCH`);

ALTER TABLE `finchqeuestatement` DROP INDEX `SYS_C0049149`;
ALTER TABLE `finchqeuestatement` ADD INDEX `SYS_C0049149` (`COOP_ID`, `CHEQUEBOOK_NO`, `BANK_CODE`, `BANK_BRANCH`, `CHEQUE_NO`, `SEQ_NO`);

ALTER TABLE `finclosebankday` DROP INDEX `SYS_C0049155`;
ALTER TABLE `finclosebankday` ADD INDEX `SYS_C0049155` (`COOP_ID`, `ACCOUNT_NO`, `BANK_CODE`, `BANKBRANCH_CODE`, `CLOSE_DATE`);

ALTER TABLE `finconstant` DROP INDEX `SYS_C0049157`;
ALTER TABLE `finconstant` ADD INDEX `SYS_C0049157` (`COOP_ID`);

ALTER TABLE `fincontackmaster` DROP INDEX `SYS_C0049167`;
ALTER TABLE `fincontackmaster` ADD INDEX `SYS_C0049167` (`COOP_ID`, `CONTACK_NO`);

ALTER TABLE `finitemposttobank` DROP INDEX `SYS_C0049171`;
ALTER TABLE `finitemposttobank` ADD INDEX `SYS_C0049171` (`COOP_ID`, `ENTRY_DATE`, `SEQ_NO`);

ALTER TABLE `finitemposttobank` DROP INDEX `INDX_POSTTOBANK_ACCID`;
ALTER TABLE `finitemposttobank` ADD INDEX `INDX_POSTTOBANK_ACCID` (`ACCOUNT_NO`);

ALTER TABLE `finmapstatus` DROP INDEX `SYS_C0049175`;
ALTER TABLE `finmapstatus` ADD INDEX `SYS_C0049175` (`COOP_ID`, `ITEMCODE`, `APPLICATION`, `STATUS`);

ALTER TABLE `finreportcloseday` DROP INDEX `SYS_C0049179`;
ALTER TABLE `finreportcloseday` ADD INDEX `SYS_C0049179` (`COOP_ID`, `FINCLOSEDAY_DATE`, `FINSLIP_NO`, `SEQ_NO`);

ALTER TABLE `finrq_cashflowstat` DROP INDEX `SYS_C0049187`;
ALTER TABLE `finrq_cashflowstat` ADD INDEX `SYS_C0049187` (`COOP_ID`, `OPERATE_DATE`, `SEQ_NO`, `FINSLIP_NO`);

ALTER TABLE `finrqcashflow` DROP INDEX `SYS_C0049182`;
ALTER TABLE `finrqcashflow` ADD INDEX `SYS_C0049182` (`COOP_ID`, `REQ_CASHNO`);

ALTER TABLE `fintableuserdetail` DROP INDEX `SYS_C0049205`;
ALTER TABLE `fintableuserdetail` ADD INDEX `SYS_C0049205` (`COOP_ID`, `USER_NAME`, `OPDATEWORK`, `SEQNO`);

ALTER TABLE `fintableusermaster` DROP INDEX `SYS_C0049210`;
ALTER TABLE `fintableusermaster` ADD INDEX `SYS_C0049210` (`COOP_ID`, `USER_NAME`, `OPDATEWORK`);

ALTER TABLE `fintax` DROP INDEX `SYS_C0049213`;
ALTER TABLE `fintax` ADD UNIQUE `SYS_C0049213` (`COOP_ID`, `TAXDOC_NO`);

ALTER TABLE `fintaxtype` DROP INDEX `SYS_C0049215`;
ALTER TABLE `fintaxtype` ADD INDEX `SYS_C0049215` (`COOP_ID`, `TAX_CODE`);

ALTER TABLE `finucfchequeformat` DROP INDEX `SYS_C0049220`;
ALTER TABLE `finucfchequeformat` ADD INDEX `SYS_C0049220` (`COOP_ID`, `BANK_CODE`, `CHEQUE_TYPE`, `PRINTER_TYPE`);

ALTER TABLE `finucfictaxtype` DROP INDEX `SYS_C0049222`;
ALTER TABLE `finucfictaxtype` ADD INDEX `SYS_C0049222` (`COOP_ID`, `ICTAXTYPE_CODE`);

ALTER TABLE `finucfstatus` DROP INDEX `SYS_C0049226`;
ALTER TABLE `finucfstatus` ADD INDEX `SYS_C0049226` (`COOP_ID`, `STATUS`);

ALTER TABLE `hrdetailpnd1` DROP INDEX `SYS_C0014482`;
ALTER TABLE `hrdetailpnd1` ADD INDEX `SYS_C0014482` (`SEQ_NO`);

ALTER TABLE `hremployee91` DROP INDEX `SYS_C0014485`;
ALTER TABLE `hremployee91` ADD INDEX `SYS_C0014485` (`EMPLOYE_NO`, `SEQ_NO`);

ALTER TABLE `hrnmlassessdea` DROP INDEX `SYS_C0014488`;
ALTER TABLE `hrnmlassessdea` ADD INDEX `SYS_C0014488` (`EMPLID`, `SEQ_NO`);

ALTER TABLE `hrnmlassesstestdea` DROP INDEX `SYS_C0014492`;
ALTER TABLE `hrnmlassesstestdea` ADD INDEX `SYS_C0014492` (`SEQ_NO`, `EMPLID`);

ALTER TABLE `hrnmlassesstestdeb` DROP INDEX `SYS_C0014496`;
ALTER TABLE `hrnmlassesstestdeb` ADD INDEX `SYS_C0014496` (`SEQ_NO`, `EMPLID`);

ALTER TABLE `hrnmlassesstestdec` DROP INDEX `SYS_C0014500`;
ALTER TABLE `hrnmlassesstestdec` ADD INDEX `SYS_C0014500` (`SEQ_NO`, `EMPLID`);

ALTER TABLE `hrnmlbkemply` DROP INDEX `SYS_C0014504`;
ALTER TABLE `hrnmlbkemply` ADD INDEX `SYS_C0014504` (`EMPLID`, `SEQ_NO`, `YEAR`);

ALTER TABLE `hrnmlcandidatemas` DROP INDEX `SYS_C0014507`;
ALTER TABLE `hrnmlcandidatemas` ADD INDEX `SYS_C0014507` (`SEQ_NO`);

ALTER TABLE `hrnmldet_incomedea` DROP INDEX `SYS_C0014513`;
ALTER TABLE `hrnmldet_incomedea` ADD INDEX `SYS_C0014513` (`YEART`, `MONTHT`, `EMPLOYE_NO`, `SECLAW`, `PERIOD_PAY`);

ALTER TABLE `hrnmldischangedea` DROP INDEX `SYS_C0014517`;
ALTER TABLE `hrnmldischangedea` ADD INDEX `SYS_C0014517` (`EXTOR_SEQ`, `EMPLID`);

ALTER TABLE `hrnmldischangedeb` DROP INDEX `SYS_C0014522`;
ALTER TABLE `hrnmldischangedeb` ADD INDEX `SYS_C0014522` (`EXTOR_SEQ`, `EMPLID`, `SEQ_NO`);

ALTER TABLE `hrnmldraweduadea` DROP INDEX `SYS_C0014526`;
ALTER TABLE `hrnmldraweduadea` ADD INDEX `SYS_C0014526` (`SEQ_NO`, `EMPLID`);

ALTER TABLE `hrnmldrawhospdea` DROP INDEX `SYS_C0014530`;
ALTER TABLE `hrnmldrawhospdea` ADD INDEX `SYS_C0014530` (`SEQ_NO`, `EMPLID`);

ALTER TABLE `hrnmlemplinfodea` DROP INDEX `SYS_C0014550`;
ALTER TABLE `hrnmlemplinfodea` ADD INDEX `SYS_C0014550` (`EMPLID`);

ALTER TABLE `hrnmlemplloandea` DROP INDEX `SYS_C0014558`;
ALTER TABLE `hrnmlemplloandea` ADD INDEX `SYS_C0014558` (`SEQ_NO`, `EMPLID`);

ALTER TABLE `hrnmlemplsaladea` DROP INDEX `SYS_C0014575`;
ALTER TABLE `hrnmlemplsaladea` ADD INDEX `SYS_C0014575` (`EMPLOYE_NO`, `YEAR_PAY`, `MONTH_PAY`, `PERIOD_PAY`);

ALTER TABLE `hrnmlemplsalamas` DROP INDEX `SYS_C0014580`;
ALTER TABLE `hrnmlemplsalamas` ADD INDEX `SYS_C0014580` (`EMPLOYE_NO`, `YEAR_PAY`, `MONTH_PAY`, `PERIOD_PAY`);

ALTER TABLE `hrnmlempstndsecudeb` DROP INDEX `SYS_C0014591`;
ALTER TABLE `hrnmlempstndsecudeb` ADD INDEX `SYS_C0014591` (`EMPLID`);

ALTER TABLE `hrnmlhealthdea` DROP INDEX `SYS_C0014595`;
ALTER TABLE `hrnmlhealthdea` ADD INDEX `SYS_C0014595` (`SEQ_NO`, `EMPLID`);

ALTER TABLE `hrnmlholdassetdea` DROP INDEX `SYS_C0014599`;
ALTER TABLE `hrnmlholdassetdea` ADD INDEX `SYS_C0014599` (`ASSET_NO`, `EMPLID`);

ALTER TABLE `hrnmlholdassetdeb` DROP INDEX `SYS_C0014604`;
ALTER TABLE `hrnmlholdassetdeb` ADD INDEX `SYS_C0014604` (`ASSET_NO`, `EMPLID`, `SEQ_NO`);

ALTER TABLE `hrnmllifeinsurancedea` DROP INDEX `SYS_C0014608`;
ALTER TABLE `hrnmllifeinsurancedea` ADD INDEX `SYS_C0014608` (`SEQ_NO`, `EMPLID`);

ALTER TABLE `hrnmlloanhomedea` DROP INDEX `SYS_C0014612`;
ALTER TABLE `hrnmlloanhomedea` ADD INDEX `SYS_C0014612` (`LOANHOME_ID`, `EMPLID`);

ALTER TABLE `hrnmlpenaltydea` DROP INDEX `SYS_C0014616`;
ALTER TABLE `hrnmlpenaltydea` ADD INDEX `SYS_C0014616` (`SEQ_NO`, `EMPLID`);

ALTER TABLE `hrnmlreducdea` DROP INDEX `SYS_C0014623`;
ALTER TABLE `hrnmlreducdea` ADD INDEX `SYS_C0014623` (`SEQ_NO`, `EMPLID`, `TAXYEAR`, `TAXMONTH`, `PERIOD_PAY`);

ALTER TABLE `hrnmlreqtotdea` DROP INDEX `SYS_C0014626`;
ALTER TABLE `hrnmlreqtotdea` ADD INDEX `SYS_C0014626` (`REQTOTID`);

ALTER TABLE `hrnmlreqtotdeb` DROP INDEX `SYS_C0014631`;
ALTER TABLE `hrnmlreqtotdeb` ADD INDEX `SYS_C0014631` (`REQTOTID`, `EMPLID`, `SEQ_NO`);

ALTER TABLE `hrnmlslipdea` DROP INDEX `SYS_C0014636`;
ALTER TABLE `hrnmlslipdea` ADD INDEX `SYS_C0014636` (`EMPLOYE_NO`, `MONTH_NUM`, `SEQ_NO`, `PERIOD_PAY`);





ALTER TABLE `hrnmltaxsalarydea` DROP INDEX `SYS_C0014643`;
ALTER TABLE `hrnmltaxsalarydea` ADD INDEX `SYS_C0014643` (`SEQ_NO`, `BRANCH_ID`, `EMPLOYE_NO`, `TAXYEAR`, `TAXMONTH`, `PERIOD_PAY`);

ALTER TABLE `hrnmltimerecorddea` DROP INDEX `SYS_C0014646`;
ALTER TABLE `hrnmltimerecorddea` ADD INDEX `SYS_C0014646` (`EMPLID`, `YYYYMMDD`);

ALTER TABLE `hrnmltimerecordhisdea` DROP INDEX `SYS_C0014652`;
ALTER TABLE `hrnmltimerecordhisdea` ADD INDEX `SYS_C0014652` (`EMPLID`, `SEQ_DMY`, `YYYYMMDD`);

ALTER TABLE `hrnmlwelfareemployeedea` DROP INDEX `SYS_C0014660`;
ALTER TABLE `hrnmlwelfareemployeedea` ADD INDEX `SYS_C0014660` (`EMP_SEQ`, `EMPLID`);

ALTER TABLE `hrnmlwelfarehelpsundea` DROP INDEX `SYS_C0014664`;
ALTER TABLE `hrnmlwelfarehelpsundea` ADD INDEX `SYS_C0014664` (`HELP_SEQ`, `EMPLID`);

ALTER TABLE `hrnmlworkeffcdea` DROP INDEX `SYS_C006537`;
ALTER TABLE `hrnmlworkeffcdea` ADD INDEX `SYS_C006537` (`SEQ_NO`, `EMPLID`);

ALTER TABLE `hrnmlwscheduledea` DROP INDEX `SYS_C0014671`;
ALTER TABLE `hrnmlwscheduledea` ADD INDEX `SYS_C0014671` (`SCHYEARID`, `SCHMONTHID`);

ALTER TABLE `hrnmlwscheduledeb` DROP INDEX `SYS_C0014677`;
ALTER TABLE `hrnmlwscheduledeb` ADD INDEX `SYS_C0014677` (`SCHYEARID`, `SCHMONTHID`, `EMPLID`, `SEQ_NO`);

ALTER TABLE `hrnpayroll` DROP INDEX `SYS_C0022867`;
ALTER TABLE `hrnpayroll` ADD INDEX `SYS_C0022867` (`PAY_YEAR`, `PAY_MONTH`, `SEQ_PAY`, `EMPLID`);

ALTER TABLE `hrnpayroll_salary` DROP INDEX `SYS_C0022843`;
ALTER TABLE `hrnpayroll_salary` ADD INDEX `SYS_C0022843` (`SEQ_PAY`);

ALTER TABLE `hrnpayroll_set` DROP INDEX `SYS_C0022847`;
ALTER TABLE `hrnpayroll_set` ADD INDEX `SYS_C0022847` (`SET_NO`, `SEQ_PAY`, `EMPLID`);

ALTER TABLE `hrnpayroll_taxcfg` DROP INDEX `SYS_C0022851`;
ALTER TABLE `hrnpayroll_taxcfg` ADD INDEX `SYS_C0022851` (`SEQ_TAX`);

ALTER TABLE `hrnpayroll_taxset` DROP INDEX `SYS_C0022856`;
ALTER TABLE `hrnpayroll_taxset` ADD INDEX `SYS_C0022856` (`PAY_YEAR`, `PAY_MONTH`, `SEQ_TAX`, `EMPLID`);

ALTER TABLE `hrnucfincome_type` DROP INDEX `SYS_C0022860`;
ALTER TABLE `hrnucfincome_type` ADD INDEX `SYS_C0022860` (`INCOMETYPE_ID`);

ALTER TABLE `hrnucftax_rate` DROP INDEX `SYS_C0022873`;
ALTER TABLE `hrnucftax_rate` ADD INDEX `SYS_C0022873` (`TAXYEAR`, `TAXRATE`);

ALTER TABLE `hrpnd1` DROP INDEX `SYS_C0014714`;
ALTER TABLE `hrpnd1` ADD INDEX `SYS_C0014714` (`SEQ_NO`);

ALTER TABLE  `hrpnd1k` DROP INDEX `SYS_C0014716`;
ALTER TABLE  `hrpnd1k` ADD INDEX `SYS_C0014716` (`SEQ_NO`);

ALTER TABLE `hrpnd1ksubdata` DROP INDEX `SYS_C0014718`;
ALTER TABLE `hrpnd1ksubdata`  ADD INDEX `SYS_C0014718` (`SEQ_NO`);

ALTER TABLE `hrpnd1subdata` DROP INDEX `SYS_C0014722`;
ALTER TABLE `hrpnd1subdata` ADD INDEX `SYS_C0014722` (`YEART`, `MONTHT`, `EMPLOYE_NO`);

ALTER TABLE `hrpndsubmit` DROP INDEX `SYS_C0014726`;
ALTER TABLE `hrpndsubmit` ADD INDEX `SYS_C0014726` (`YEART`, `MONTHT`, `EMPLOYE_NO`);

ALTER TABLE `hrrepmaster` DROP INDEX `SYS_C0014728`;
ALTER TABLE `hrrepmaster` ADD INDEX `SYS_C0014728` (`GREP_ID`);

ALTER TABLE `hrrep_detail` DROP INDEX `SYS_C0014731`;
ALTER TABLE `hrrep_detail` ADD INDEX `SYS_C0014731` (`GREP_ID`, `DREP_ID`);

ALTER TABLE `hrssoma` DROP INDEX `SYS_C0014733`;
ALTER TABLE `hrssoma` ADD INDEX `SYS_C0014733` (`SEQ_NO`);

ALTER TABLE `hrtemppnd91` DROP INDEX `SYS_C0014735`;
ALTER TABLE `hrtemppnd91` ADD INDEX `SYS_C0014735` (`SEQ_NO`);

ALTER TABLE `hrucfcompany` DROP INDEX `SYS_C0014742`;
ALTER TABLE `hrucfcompany` ADD INDEX `SYS_C0014742` (`SEQ_NUM`);

ALTER TABLE `hrucfcompprof` DROP INDEX `SYS_C0014744`;
ALTER TABLE `hrucfcompprof` ADD INDEX `SYS_C0014744` (`COMPID`);

ALTER TABLE `hrucfincome` DROP INDEX `SYS_C0014749`;
ALTER TABLE `hrucfincome` ADD INDEX `SYS_C0014749` (`INCOME_ID`);

ALTER TABLE `hrucfincome_type` DROP INDEX `SYS_C0014751`;
ALTER TABLE `hrucfincome_type` ADD INDEX `SYS_C0014751` (`INCOMETYPE_ID`);

ALTER TABLE `hrucflaw` DROP INDEX `SYS_C0014753`;
ALTER TABLE `hrucflaw` ADD INDEX `SYS_C0014753` (`SEQ_LAW`);

ALTER TABLE `hrucfloantype` DROP INDEX `SYS_C0014759`;
ALTER TABLE `hrucfloantype` ADD INDEX `SYS_C0014759` (`LOANTYPEID`);

ALTER TABLE `hrucfoutcome` DROP INDEX `SYS_C0014761`;
ALTER TABLE `hrucfoutcome` ADD INDEX `SYS_C0014761` (`OUTCOME_ID`);

ALTER TABLE `hrucfpenalty` DROP INDEX `SYS_C0014763`;
ALTER TABLE `hrucfpenalty` ADD INDEX `SYS_C0014763` (`PENALT_ID`);

ALTER TABLE `hrucfperiod` DROP INDEX `SYS_C0014765`;
ALTER TABLE `hrucfperiod` ADD INDEX `SYS_C0014765` (`PERIOD_ID`);

ALTER TABLE `hrucfposition_w` DROP INDEX `SYS_C0014771`;
ALTER TABLE `hrucfposition_w` ADD INDEX `SYS_C0014771` (`SIDEID`, `DEPTID`, `POSIWID`);

ALTER TABLE `hrucfprivilege` DROP INDEX `SYS_C0014774`;
ALTER TABLE `hrucfprivilege` ADD INDEX `SYS_C0014774` (`POSIWID`, `LEAVTYPEID`);

ALTER TABLE `hrucfstatusweb` DROP INDEX `SYS_C0014781`;
ALTER TABLE `hrucfstatusweb` ADD INDEX `SYS_C0014781` (`SEQ_WEB`);

ALTER TABLE `hrucftax_rate` DROP INDEX `SYS_C0014793`;
ALTER TABLE `hrucftax_rate` ADD INDEX `SYS_C0014793` (`TAXYEAR`, `TAXRATE`);

ALTER TABLE `hrucftaxcondi` DROP INDEX `SYS_C0014786`;
ALTER TABLE `hrucftaxcondi` ADD INDEX `SYS_C0014786` (`TAXCON_ID`);

ALTER TABLE `hrucftaxperiod` DROP INDEX `SYS_C0014788`;
ALTER TABLE `hrucftaxperiod` ADD INDEX `SYS_C0014788` (`SEQ_PERIOD`);

ALTER TABLE `hrucftaxyear` DROP INDEX `SYS_C0014790`;
ALTER TABLE `hrucftaxyear` ADD INDEX `SYS_C0014790` (`SEQ_YEAR`);

ALTER TABLE `hrucftimeinterval` DROP INDEX `SYS_C0014795`;
ALTER TABLE `hrucftimeinterval` ADD INDEX `SYS_C0014795` (`TIMEINTERVAL_ID`);

ALTER TABLE `hrucfwfemtype` DROP INDEX `SYS_C0014798`;
ALTER TABLE `hrucfwfemtype` ADD INDEX `SYS_C0014798` (`WFEM_TYPE`);

ALTER TABLE `insgroupmaster` DROP INDEX `INDEX_INSM01`;
ALTER TABLE `insgroupmaster` ADD INDEX `INDEX_INSM01` (`MEMBER_NO`);

ALTER TABLE `insgroupmaster` DROP INDEX `INDX_MEMIN`;
ALTER TABLE `insgroupmaster` ADD INDEX `INDX_MEMIN` (`MEMBER_NO`, `INSTYPE_CODE`, `LEVEL_CODE`);

ALTER TABLE `inslevelcost` DROP INDEX `XIF437INSLEVELCOST`;
ALTER TABLE `inslevelcost` ADD INDEX `XIF437INSLEVELCOST` (`INSTYPE_CODE`);

ALTER TABLE `insreceiveyear` DROP INDEX `SYS_C0014846`;
ALTER TABLE `insreceiveyear` ADD INDEX `SYS_C0014846` (`DIV_YEAR`, `MEMBER_NO`);

ALTER TABLE `insreqnew` DROP INDEX `INDEX_MEMNO01`;
ALTER TABLE `insreqnew` ADD INDEX `INDEX_MEMNO01` (`MEMBER_NO`);

ALTER TABLE `insreqresign` DROP INDEX `INDEX_MEM02`;
ALTER TABLE `insreqresign` ADD INDEX `INDEX_MEM02` (`MEMBER_NO`);

ALTER TABLE `kpmastreceive` DROP INDEX `KPMR_RECEIPT`;
ALTER TABLE `kpmastreceive` ADD INDEX `KPMR_RECEIPT` (`RECEIPT_NO`);
ALTER TABLE `kpmastreceive` DROP INDEX `KPMR_RECVPERIOD`;
ALTER TABLE `kpmastreceive` ADD INDEX `KPMR_RECVPERIOD` (`RECV_PERIOD`);
ALTER TABLE `kpmastreceive` DROP INDEX `KPMR_MEMCOOPID`;
ALTER TABLE `kpmastreceive` ADD INDEX `KPMR_MEMCOOPID` (`MEMCOOP_ID`);
ALTER TABLE `kpmastreceive` DROP INDEX `KPMR_REFMEMCOOPID`;
ALTER TABLE `kpmastreceive` ADD INDEX `KPMR_REFMEMCOOPID` (`REFMEMCOOP_ID`);
ALTER TABLE `kpmastreceive` DROP INDEX `KPMR_MEMNO`;
ALTER TABLE `kpmastreceive` ADD INDEX `KPMR_MEMNO` (`MEMBER_NO`);
ALTER TABLE `kpmastreceive` DROP INDEX `KPMR_REFMEMNO`;
ALTER TABLE `kpmastreceive` ADD INDEX `KPMR_REFMEMNO` (`REF_MEMBNO`);
ALTER TABLE `kpmastreceive` DROP INDEX `KPMR_MEMBTYPE`;
ALTER TABLE `kpmastreceive` ADD INDEX `KPMR_MEMBTYPE` (`MEMBTYPE_CODE`);
ALTER TABLE `kpmastreceive` DROP INDEX `KPMR_DEPARTMENT`;
ALTER TABLE `kpmastreceive` ADD INDEX `KPMR_DEPARTMENT` (`DEPARTMENT_CODE`);
ALTER TABLE `kpmastreceive` DROP INDEX `KPMR_MEMBSECTION`;
ALTER TABLE `kpmastreceive` ADD INDEX `KPMR_MEMBSECTION` (`MEMBSECTION_CODE`);
ALTER TABLE `kpmastreceive` DROP INDEX `KPMR_MEMBGROUP`;
ALTER TABLE `kpmastreceive` ADD INDEX `KPMR_MEMBGROUP` (`MEMBGROUP_CODE`);

ALTER TABLE `kpmastreceivedet` DROP INDEX `KPMRD_SHRLONTYPE`;
ALTER TABLE `kpmastreceivedet` ADD INDEX `KPMRD_SHRLONTYPE` (`SHRLONTYPE_CODE`);
ALTER TABLE `kpmastreceivedet` DROP INDEX `KPMRD_KEEPTYPE`;
ALTER TABLE `kpmastreceivedet` ADD INDEX `KPMRD_KEEPTYPE` (`KEEPITEMTYPE_CODE`);
ALTER TABLE `kpmastreceivedet` DROP INDEX `KPMRD_CONTNO`;
ALTER TABLE `kpmastreceivedet` ADD INDEX `KPMRD_CONTNO` (`LOANCONTRACT_NO`);
ALTER TABLE `kpmastreceivedet` DROP INDEX `KPMRD_KEEPTYPE`;
ALTER TABLE `kpmastreceivedet` ADD INDEX `KPMRD_KEEPTYPE` (`KEEPITEMTYPE_CODE`);
ALTER TABLE `kpmastreceivedet` DROP INDEX `KPMRD_MEMNO`;
ALTER TABLE `kpmastreceivedet` ADD INDEX `KPMRD_MEMNO` (`MEMBER_NO`);
ALTER TABLE `kpmastreceivedet` DROP INDEX `KPMRD_RECVPERIOD`;
ALTER TABLE `kpmastreceivedet` ADD INDEX `KPMRD_RECVPERIOD` (`RECV_PERIOD`);
ALTER TABLE `kpmastreceivedet` DROP INDEX `KPMRD_REFMEMCOOPID`;
ALTER TABLE `kpmastreceivedet` ADD INDEX `KPMRD_REFMEMCOOPID` (`REFMEMCOOP_ID`);
ALTER TABLE `kpmastreceivedet` DROP INDEX `KPMRD_MEMCOOPID`;
ALTER TABLE `kpmastreceivedet` ADD INDEX `KPMRD_MEMCOOPID` (`MEMCOOP_ID`);

ALTER TABLE `kprcvprocrepshort` DROP INDEX `SYS_C00112284`;
ALTER TABLE `kprcvprocrepshort` ADD INDEX `SYS_C00112284` (`MEMBER_NO`, `RECV_PERIOD`, `SEQ_NO`);

ALTER TABLE `kptempreceiptno` DROP INDEX `SYS_C0056196`;
ALTER TABLE `kptempreceiptno` ADD INDEX `SYS_C0056196` (`COOP_ID`, `KPSLIP_NO`);

ALTER TABLE `kptempreceive` DROP INDEX `KPTR_MEMNO`;
ALTER TABLE `kptempreceive` ADD INDEX `KPTR_MEMNO` (`MEMBER_NO`);
ALTER TABLE `kptempreceive` DROP INDEX `KPTR_REFMEMNO`;
ALTER TABLE `kptempreceive` ADD INDEX `KPTR_REFMEMNO` (`REF_MEMBNO`);
ALTER TABLE `kptempreceive` DROP INDEX `KPTR_RECVPERIOD`;
ALTER TABLE `kptempreceive` ADD INDEX `KPTR_RECVPERIOD` (`RECV_PERIOD`);
ALTER TABLE `kptempreceive` DROP INDEX `KPTR_MEMBGROUP`;
ALTER TABLE `kptempreceive` ADD INDEX `KPTR_MEMBGROUP` (`MEMBGROUP_CODE`);
ALTER TABLE `kptempreceive` DROP INDEX `KPTR_RECEIPT`;
ALTER TABLE `kptempreceive` ADD INDEX `KPTR_RECEIPT` (`RECEIPT_DATE`);
ALTER TABLE `kptempreceive` DROP INDEX `KPTR_MEMCOOPID`;
ALTER TABLE `kptempreceive` ADD INDEX `KPTR_MEMCOOPID` (`MEMCOOP_ID`);
ALTER TABLE `kptempreceive` DROP INDEX `KPTR_MEMBTYPE`;
ALTER TABLE `kptempreceive` ADD INDEX `KPTR_MEMBTYPE` (`MEMBTYPE_CODE`);
ALTER TABLE `kptempreceive` DROP INDEX `KPTR_DEPARTMENT`;
ALTER TABLE `kptempreceive` ADD INDEX `KPTR_DEPARTMENT` (`DEPARTMENT_CODE`);
ALTER TABLE `kptempreceive` DROP INDEX `KPTR_MEMBSECTION`;
ALTER TABLE `kptempreceive` ADD INDEX `KPTR_MEMBSECTION` (`MEMBSECTION_CODE`);
ALTER TABLE `kptempreceive` DROP INDEX `KPTR_REFMEMCOOPID`;
ALTER TABLE `kptempreceive` ADD INDEX `KPTR_REFMEMCOOPID` (`REFMEMCOOP_ID`);

ALTER TABLE `kptempreceivedet` DROP INDEX `KPTRD_MEMCOOPID`;
ALTER TABLE `kptempreceivedet` ADD INDEX `KPTRD_MEMCOOPID` (`MEMCOOP_ID`);
ALTER TABLE `kptempreceivedet` DROP INDEX `KPTRD_MEMNO`;
ALTER TABLE `kptempreceivedet` ADD INDEX `KPTRD_MEMNO` (`MEMBER_NO`);
ALTER TABLE `kptempreceivedet` DROP INDEX `KPTRD_RECVPERIOD`;
ALTER TABLE `kptempreceivedet` ADD INDEX `KPTRD_RECVPERIOD` (`RECV_PERIOD`);
ALTER TABLE `kptempreceivedet` DROP INDEX `KPTRD_CONTNO`;
ALTER TABLE `kptempreceivedet` ADD INDEX `KPTRD_CONTNO` (`LOANCONTRACT_NO`);
ALTER TABLE `kptempreceivedet` DROP INDEX `KPTRD_KEEPTYPE`;
ALTER TABLE `kptempreceivedet` ADD INDEX `KPTRD_KEEPTYPE` (`KEEPITEMTYPE_CODE`);
ALTER TABLE `kptempreceivedet` DROP INDEX `KPTRD_SHRLONTYPE`;
ALTER TABLE `kptempreceivedet` ADD INDEX `KPTRD_SHRLONTYPE` (`SHRLONTYPE_CODE`);
ALTER TABLE `kptempreceivedet` DROP INDEX `KPTRD_REFMEMNO`;
ALTER TABLE `kptempreceivedet` ADD INDEX `KPTRD_REFMEMNO` (`REF_MEMBNO`);
ALTER TABLE `kptempreceivedet` DROP INDEX `KPTRD_REFMEMCOOPID`;
ALTER TABLE `kptempreceivedet` ADD INDEX `KPTRD_REFMEMCOOPID` (`REFMEMCOOP_ID`);

ALTER TABLE `kpucfkeepitemtype` DROP INDEX `SYS_C0024859`;
ALTER TABLE `kpucfkeepitemtype` ADD INDEX `SYS_C0024859` (`COOP_ID`, `KEEPITEMTYPE_CODE`);

ALTER TABLE `lccfgrploanpermiss` DROP INDEX `XPKLCCFGRPLOANPERMISS`;
ALTER TABLE `lccfgrploanpermiss` ADD INDEX `XPKLCCFGRPLOANPERMISS` (`COOP_ID`, `LOANPERMGRP_CODE`);

ALTER TABLE `lccfloanconstant` DROP INDEX `XPKLCCFLOANCONSTANT`;
ALTER TABLE `lccfloanconstant` ADD INDEX `XPKLCCFLOANCONSTANT` (`COOP_ID`);

ALTER TABLE `lccfloanintrate` DROP INDEX `XPKLCCFLOANINTRATE`;
ALTER TABLE `lccfloanintrate` ADD INDEX `XPKLCCFLOANINTRATE` (`COOP_ID`, `LOANINTRATE_CODE`);

ALTER TABLE `lccfloanintratedet` DROP INDEX `XPKLCCFLOANINTRATEDET`;
ALTER TABLE `lccfloanintratedet` ADD INDEX `XPKLCCFLOANINTRATEDET` (`COOP_ID`, `LOANINTRATE_CODE`, `SEQ_NO`);

ALTER TABLE `lccfloantype` DROP INDEX `XPKLCCFLOANTYPE`;
ALTER TABLE `lccfloantype` ADD INDEX `XPKLCCFLOANTYPE` (`COOP_ID`, `LOANTYPE_CODE`);

ALTER TABLE `lccfloantypecolluse` DROP INDEX `XPKLCCFLOANTYPECOLLUSE`;
ALTER TABLE `lccfloantypecolluse` ADD INDEX `XPKLCCFLOANTYPECOLLUSE` (`COOP_ID`, `LOANTYPE_CODE`, `LOANCOLLTYPE_CODE`, `COLLMASTTYPE_CODE`);

ALTER TABLE `lccfloantypeintspc` DROP INDEX `XPKLCCFLOANTYPEINTSPC`;
ALTER TABLE `lccfloantypeintspc` ADD INDEX `XPKLCCFLOANTYPEINTSPC` (`COOP_ID`, `LOANTYPE_CODE`, `SEQ_NO`);

ALTER TABLE `lccfloantypeperiod` DROP INDEX `XPKLCCFLOANTYPEPERIOD`;
ALTER TABLE `lccfloantypeperiod` ADD INDEX `XPKLCCFLOANTYPEPERIOD` (`COOP_ID`, `LOANTYPE_CODE`);

ALTER TABLE `lcclsmthbalance` DROP INDEX `SYS_C0056189`;
ALTER TABLE `lcclsmthbalance` ADD INDEX `SYS_C0056189` (`COOP_ID`, `LOANCONTRACT_NO`, `CLSMTH_PERIOD`);

ALTER TABLE `lccollmaster` DROP INDEX `XPKLCCOLLMASTER`;
ALTER TABLE `lccollmaster` ADD INDEX `XPKLCCOLLMASTER` (`BRANCH_ID`, `COLLMAST_NO`);

ALTER TABLE `lccontcoll` DROP INDEX `XPKLCCONTCOLL`;
ALTER TABLE `lccontcoll` ADD INDEX `XPKLCCONTCOLL` (`COOP_ID`, `LOANCONTRACT_NO`, `SEQ_NO`);

ALTER TABLE `lccontintspc` DROP INDEX `XPKLCCONTINTSPC`;
ALTER TABLE `lccontintspc` ADD INDEX `XPKLCCONTINTSPC` (`COOP_ID`, `LOANCONTRACT_NO`, `SEQ_NO`);

ALTER TABLE `lccontmaster` DROP INDEX `XPKLCCONTMASTER`;
ALTER TABLE `lccontmaster` ADD INDEX `XPKLCCONTMASTER` (`COOP_ID`, `LOANCONTRACT_NO`);

ALTER TABLE `lccontstatement` DROP INDEX `XPKLCCONTSTATEMENT`;
ALTER TABLE `lccontstatement` ADD INDEX `XPKLCCONTSTATEMENT` (`COOP_ID`, `LOANCONTRACT_NO`, `SEQ_NO`);

ALTER TABLE `lcestloanshortlong` DROP INDEX `SYS_C0056190`;
ALTER TABLE `lcestloanshortlong` ADD INDEX `SYS_C0056190` (`COOP_ID`, `EST_PERIOD`, `CONCOOP_ID`, `LOANCONTRACT_NO`);

ALTER TABLE `lcnoticemthrecv` DROP INDEX `XPKLCNOTICEMTHRECV`;
ALTER TABLE `lcnoticemthrecv` ADD INDEX `XPKLCNOTICEMTHRECV` (`COOP_ID`, `NOTICE_DOCNO`);

ALTER TABLE `lcnoticemthrecvdet` DROP INDEX `XPKLCNOTICEMTHRECVDET`;
ALTER TABLE `lcnoticemthrecvdet` ADD INDEX `XPKLCNOTICEMTHRECVDET` (`COOP_ID`, `NOTICE_DOCNO`, `SEQ_NO`);

ALTER TABLE `lcreqcontadjust` DROP INDEX `XPKLCREQCONTADJUST`;
ALTER TABLE `lcreqcontadjust` ADD INDEX `XPKLCREQCONTADJUST` (`COOP_ID`, `CONTADJUST_DOCNO`);

ALTER TABLE `lcreqcontadjustcoll` DROP INDEX `XPKLCREQCONTADJUSTCOLL`;
ALTER TABLE `lcreqcontadjustcoll` ADD INDEX `XPKLCREQCONTADJUSTCOLL` (`COOP_ID`, `CONTADJUST_DOCNO`, `CONTADJUST_TYPE`, `SEQ_NO`);

ALTER TABLE `lcreqcontadjustdet` DROP INDEX `XPKLCREQCONTADJUSTDET`;
ALTER TABLE `lcreqcontadjustdet` ADD INDEX `XPKLCREQCONTADJUSTDET` (`COOP_ID`, `CONTADJUST_DOCNO`, `CONTADJUST_CODE`);

ALTER TABLE `lcreqcontadjustintspc` DROP INDEX `XPKLCREQCONTADJUSTINTSPC`;
ALTER TABLE `lcreqcontadjustintspc` ADD INDEX `XPKLCREQCONTADJUSTINTSPC` (`COOP_ID`, `CONTADJUST_DOCNO`, `CONTADJUST_TYPE`, `SEQ_NO`);

ALTER TABLE `lcreqloan` DROP INDEX `XPKLCREQLOAN`;
ALTER TABLE `lcreqloan` ADD INDEX `XPKLCREQLOAN` (`COOP_ID`, `LOANREQUEST_DOCNO`);

ALTER TABLE `lcreqloanclr` DROP INDEX `XPKLCREQLOANCLR`;
ALTER TABLE `lcreqloanclr` ADD INDEX `XPKLCREQLOANCLR` (`COOP_ID`, `LOANREQUEST_DOCNO`, `SEQ_NO`);

ALTER TABLE `lcreqloanclrother` DROP INDEX `XPKLCREQLOANCLROTHER`;
ALTER TABLE `lcreqloanclrother` ADD INDEX `XPKLCREQLOANCLROTHER` (`COOP_ID`, `LOANREQUEST_DOCNO`, `SEQ_NO`);

ALTER TABLE `lcreqloancoll` DROP INDEX `XPKLCREQLOANCOLL`;
ALTER TABLE `lcreqloancoll` ADD INDEX `XPKLCREQLOANCOLL` (`COOP_ID`, `LOANREQUEST_DOCNO`, `SEQ_NO`);

ALTER TABLE `lcreqloanintspc` DROP INDEX `XPKLCREQLOANINTSPC`;
ALTER TABLE `lcreqloanintspc` ADD INDEX `XPKLCREQLOANINTSPC` (`COOP_ID`, `LOANREQUEST_DOCNO`, `SEQ_NO`);

ALTER TABLE `lcslippayin` DROP INDEX `XPKLCSLIPPAYIN`;
ALTER TABLE `lcslippayin` ADD INDEX `XPKLCSLIPPAYIN` (`COOP_ID`, `PAYINSLIP_NO`);

ALTER TABLE `lcslippayindet` DROP INDEX `XPKLCSLIPPAYINDET`;
ALTER TABLE `lcslippayindet` ADD INDEX `XPKLCSLIPPAYINDET` (`COOP_ID`, `PAYINSLIP_NO`, `SEQ_NO`);

ALTER TABLE `lcslippayinexpense` DROP INDEX `XPKLCSLIPPAYINEXPENSE`;
ALTER TABLE `lcslippayinexpense` ADD INDEX `XPKLCSLIPPAYINEXPENSE` (`COOP_ID`, `PAYINSLIP_NO`, `SEQ_NO`);

ALTER TABLE `lcslippayout` DROP INDEX `XPKLCSLIPPAYOUT`;
ALTER TABLE `lcslippayout` ADD INDEX `XPKLCSLIPPAYOUT` (`COOP_ID`, `PAYOUTSLIP_NO`);

ALTER TABLE `lcslippayoutdet` DROP INDEX `XPKLCSLIPPAYOUTDET`;
ALTER TABLE `lcslippayoutdet` ADD INDEX `XPKLCSLIPPAYOUTDET` (`COOP_ID`, `PAYOUTSLIP_NO`, `SEQ_NO`);

ALTER TABLE `lcslippayoutexpense` DROP INDEX `XPKLCSLIPPAYOUTEXPENSE`;
ALTER TABLE `lcslippayoutexpense` ADD INDEX `XPKLCSLIPPAYOUTEXPENSE` (`COOP_ID`, `PAYOUTSLIP_NO`, `SEQ_NO`);

ALTER TABLE `lcucfassettype` DROP INDEX `XPKLCUCFASSETTYPE`;
ALTER TABLE `lcucfassettype` ADD INDEX `XPKLCUCFASSETTYPE` (`ASSETTYPE_CODE`);

ALTER TABLE `lcucfbuildingtype` DROP INDEX `XPKLCUCFBUILDINGTYPE`;
ALTER TABLE `lcucfbuildingtype` ADD INDEX `XPKLCUCFBUILDINGTYPE` (`BUILDINGTYPE_CODE`);

ALTER TABLE `lcucfcollmasttype` DROP INDEX `XPKLCUCFCOLLMASTTYPE`;
ALTER TABLE `lcucfcollmasttype` ADD INDEX `XPKLCUCFCOLLMASTTYPE` (`COLLMASTTYPE_CODE`);

ALTER TABLE `lcucfloancolltype` DROP INDEX `XPKLCUCFLOANCOLLTYPE`;
ALTER TABLE `lcucfloancolltype` ADD INDEX `XPKLCUCFLOANCOLLTYPE` (`LOANCOLLTYPE_CODE`);

ALTER TABLE `lcucfloanitemtype` DROP INDEX `XPKLCUCFLOANITEMTYPE`;
ALTER TABLE `lcucfloanitemtype` ADD INDEX `XPKLCUCFLOANITEMTYPE` (`LOANITEMTYPE_CODE`);

ALTER TABLE `lcucfloanobjective` DROP INDEX `XPKLCUCFLOANOBJECTIVE`;
ALTER TABLE `lcucfloanobjective` ADD INDEX `XPKLCUCFLOANOBJECTIVE` (`COOP_ID`, `LOANOBJECTIVE_CODE`);

ALTER TABLE `lcucfsliptype` DROP INDEX `XPKLCUCFSLIPTYPE`;
ALTER TABLE `lcucfsliptype` ADD INDEX `XPKLCUCFSLIPTYPE` (`SLIPTYPE_CODE`);

ALTER TABLE `lnadjchgperiodpay` DROP INDEX `SYS_C0014925`;
ALTER TABLE `lnadjchgperiodpay` ADD INDEX `SYS_C0014925` (`CHGPERIOD_DOCNO`);

ALTER TABLE `lnaudithistory` DROP INDEX `SYS_C0014934`;
ALTER TABLE `lnaudithistory` ADD INDEX `SYS_C0014934` (`DOCNO`, `COL_ID`);

ALTER TABLE `lncfloanintrate` DROP INDEX `XPKLNLOANTYPE`;
ALTER TABLE `lncfloanintrate` ADD INDEX `XPKLNLOANTYPE` (`COOP_ID`, `LOANINTRATE_CODE`);

ALTER TABLE `lncfloanintratedet` DROP INDEX `XPKLNCFINTRATEDET`;
ALTER TABLE `lncfloanintratedet` ADD INDEX `XPKLNCFINTRATEDET` (`COOP_ID`, `LOANINTRATE_CODE`, `EFFECTIVE_DATE`, `LOWER_AMT`);

ALTER TABLE `lncfsalarybalance` DROP INDEX `SYS_C0056188`;
ALTER TABLE `lncfsalarybalance` ADD INDEX `SYS_C0056188` (`COOP_ID`, `SALARYBAL_CODE`);

ALTER TABLE `lncolldetail` DROP INDEX `XPKLNCOLLDETAIL`;
ALTER TABLE `lncolldetail` ADD INDEX `XPKLNCOLLDETAIL` (`COOP_ID`, `COLLMAST_NO`);

ALTER TABLE `lncollmastbuilding` DROP INDEX `XPKLNCOLLMASTBUILDING`;
ALTER TABLE `lncollmastbuilding` ADD INDEX `XPKLNCOLLMASTBUILDING` (`COOP_ID`, `COLLMAST_NO`, `FLOOR_NO`);

ALTER TABLE `lncollmastmemco` DROP INDEX `SYS_C0049206`;
ALTER TABLE `lncollmastmemco` ADD INDEX `SYS_C0049206` (`COOP_ID`, `COLLMAST_NO`, `MEMCOOP_ID`, `MEMCO_NO`);

ALTER TABLE `lncollmastmemco` DROP INDEX `SYS_5646`;
ALTER TABLE `lncollmastmemco` ADD INDEX `SYS_5646` (`COOP_ID`, `COLLMAST_NO`);

ALTER TABLE `lncollmastprop` DROP INDEX `XIF327LNCOLLMASTPROP`;
ALTER TABLE `lncollmastprop` ADD INDEX `XIF327LNCOLLMASTPROP` (`COLLMAST_NO`);

ALTER TABLE `lncollmastreview` DROP INDEX `XPKLNCOLLMASTREVIEW`;
ALTER TABLE `lncollmastreview` ADD INDEX `XPKLNCOLLMASTREVIEW` (`COOP_ID`, `COLLMAST_NO`, `REVIEW_NO`);

ALTER TABLE `lncontchgintrate` DROP INDEX `SYS_C0014974`;
ALTER TABLE `lncontchgintrate` ADD INDEX `SYS_C0014974` (`COOP_ID`, `LOANCONTRACT_NO`, `CHGINTRATE_DATE`);

ALTER TABLE `lncontcoll` DROP INDEX `IDX_REFCOLLNO`;
ALTER TABLE `lncontcoll` ADD INDEX `IDX_REFCOLLNO` (`REF_COLLNO`);
ALTER TABLE `lncontcoll` DROP INDEX `IDX_LOANCOLLTYPE`;
ALTER TABLE `lncontcoll` ADD INDEX `IDX_LOANCOLLTYPE` (`LOANCOLLTYPE_CODE`);
ALTER TABLE `lncontcoll` DROP INDEX `IDX_STATUS`;
ALTER TABLE `lncontcoll` ADD INDEX `IDX_STATUS` (`COLL_STATUS`);

ALTER TABLE `lncontcredit` DROP INDEX `SYS_C0012084`;
ALTER TABLE `lncontcredit` ADD UNIQUE `SYS_C0012084` (`CONTCREDIT_NO`);

ALTER TABLE `lncontintcertdet` DROP INDEX `SYS_C0056191`;
ALTER TABLE `lncontintcertdet` ADD INDEX `SYS_C0056191` (`COOP_ID`, `LOANCONTRACT_NO`);

ALTER TABLE `lncontintspc` DROP INDEX `SYS_C0014986`;
ALTER TABLE `lncontintspc` ADD INDEX `SYS_C0014986` (`COOP_ID`, `LOANCONTRACT_NO`, `SEQ_NO`);

ALTER TABLE `lncontmaster` DROP INDEX `XIE2LNCONTMASTER`;
ALTER TABLE `lncontmaster` ADD INDEX `XIE2LNCONTMASTER` (`WITHDRAWABLE_AMT`);
ALTER TABLE `lncontmaster` DROP INDEX `IDX_LNCONTMASTER_LASTPAYDATE`;
ALTER TABLE `lncontmaster` ADD INDEX `IDX_LNCONTMASTER_LASTPAYDATE` (`LASTPAYMENT_DATE`);
ALTER TABLE `lncontmaster` DROP INDEX `XIE4LNCONTMASTER`;
ALTER TABLE `lncontmaster` ADD INDEX `XIE4LNCONTMASTER` (`CONTRACT_STATUS`);
ALTER TABLE `lncontmaster` DROP INDEX `IDX_LNCONTMASTER_LASTRCVDATE`;
ALTER TABLE `lncontmaster` ADD INDEX `IDX_LNCONTMASTER_LASTRCVDATE` (`LASTRECEIVE_DATE`);
ALTER TABLE `lncontmaster` DROP INDEX `XIE1LNCONTMASTER`;
ALTER TABLE `lncontmaster` ADD INDEX `XIE1LNCONTMASTER` (`MEMBER_NO`);
ALTER TABLE `lncontmaster` DROP INDEX `XIE3LNCONTMASTER`;
ALTER TABLE `lncontmaster` ADD INDEX `XIE3LNCONTMASTER` (`COOP_ID`, `LOANTYPE_CODE`);

ALTER TABLE `lncontperiodpaydet` DROP INDEX `SYS344333WEE`;
ALTER TABLE `lncontperiodpaydet` ADD INDEX `SYS344333WEE` (`LOANCONTRACT_NO`, `COOP_ID`, `PERIOD`);

ALTER TABLE `lncontstatement` DROP INDEX `LNCONTSTATEMENTSLIPDATE`;
ALTER TABLE `lncontstatement` ADD INDEX `LNCONTSTATEMENTSLIPDATE` (`SLIP_DATE`);

ALTER TABLE `lnhouserent` DROP INDEX `SYS_C0015050`;
ALTER TABLE `lnhouserent` ADD INDEX `SYS_C0015050` (`LOANCONTRACT_NO`);

ALTER TABLE `lnloanmbtype` DROP INDEX `PK_OO332`;
ALTER TABLE `lnloanmbtype` ADD INDEX `PK_OO332` (`COOP_ID`, `TYPEOFLOAN_CODE`, `MEMBTYPE_CODE`, `LOANTYPE_CODE`);

ALTER TABLE `lnloanmbtypelevel` DROP INDEX `LNLOANMBTYPELEVEL`;
ALTER TABLE `lnloanmbtypelevel` ADD INDEX `LNLOANMBTYPELEVEL` (`MEMBTYPE_LEVEL`);

ALTER TABLE `lnloantype` DROP INDEX `XIF412LNLOANTYPE`;
ALTER TABLE `lnloantype` ADD INDEX `XIF412LNLOANTYPE` (`MANGRTPERMGRP_CODE`);

ALTER TABLE `lnloantypebuyshare` DROP INDEX `SYS_C0012744`;
ALTER TABLE `lnloantypebuyshare` ADD INDEX `SYS_C0012744` (`COOP_ID`, `LOANTYPE_CODE`, `SEQ_NO`);

ALTER TABLE `lnloantypecolluse` DROP INDEX `SYS_C0015104`;
ALTER TABLE `lnloantypecolluse` ADD INDEX `SYS_C0015104` (`COOP_ID`, `LOANTYPE_CODE`, `LOANCOLLTYPE_CODE`, `COLLMASTTYPE_CODE`);

ALTER TABLE `lnloantypedeptcancoll` DROP INDEX `SYS_C0056146`;
ALTER TABLE `lnloantypedeptcancoll` ADD INDEX `SYS_C0056146` (`COOP_ID`, `LOANTYPE_CODE`, `DEPTTYPE_CODE`);

ALTER TABLE `lnloantypegroupright` DROP INDEX `SYS_C0015115`;
ALTER TABLE `lnloantypegroupright`ADD INDEX `SYS_C0015115` (`COOP_ID`, `LOANTYPE_CODE`, `SEQ_NO`);

ALTER TABLE `lnloantypemangrtmax` DROP INDEX `SYS_C0056148`;
ALTER TABLE `lnloantypemangrtmax` ADD INDEX `SYS_C0056148` (`COOP_ID`, `LOANTYPE_CODE`, `SEQ_NO`);

ALTER TABLE `lnloantypembsubgrp` DROP INDEX `LNLOANTYPEMBSUBGRP_X`;
ALTER TABLE `lnloantypembsubgrp` ADD INDEX `LNLOANTYPEMBSUBGRP_X` (`LOANTYPE_CODE`, `SUBGROUP_CODE`);

ALTER TABLE `lnloantypeobjright` DROP INDEX `SYS_C0015126`;
ALTER TABLE `lnloantypeobjright` ADD INDEX `SYS_C0015126` (`COOP_ID`, `LOANTYPE_CODE`, `SEQ_NO`);

ALTER TABLE `lnloantypepause` DROP INDEX `SYS_C0015130`;
ALTER TABLE `lnloantypepause` ADD INDEX `SYS_C0015130` (`COOP_ID`, `LOANTYPE_CODE`, `LOANTYPE_PAUSE`);

ALTER TABLE `lnloantypepermdown` DROP INDEX `SYS_C0015138`;
ALTER TABLE `lnloantypepermdown` ADD INDEX `SYS_C0015138` (`COOP_ID`, `LOANTYPE_DOWN`, `LOANTYPE_CODE`);

ALTER TABLE `lnloantypereqgrt` DROP INDEX `LNLOANTYPEREQGRT_X`;
ALTER TABLE `lnloantypereqgrt` ADD INDEX `LNLOANTYPEREQGRT_X` (`COOP_ID`, `LOANTYPE_CODE`, `SEQ_NO`);

ALTER TABLE `lnloantyperightcoll` DROP INDEX `LNLOANTYPERIGHTCOLL_X`;
ALTER TABLE `lnloantyperightcoll` ADD INDEX `LNLOANTYPERIGHTCOLL_X` (`LOANTYPE_CODE`, `LOANCOLLTYPE_CODE`, `COLLMASTTYPE_CODE`);

ALTER TABLE `lnloantyperightcoll` DROP INDEX `SYS_C0056155`;
ALTER TABLE `lnloantyperightcoll` ADD INDEX `SYS_C0056155` (`COOP_ID`, `LOANTYPE_CODE`, `LOANCOLLTYPE_CODE`, `COLLMASTTYPE_CODE`);

ALTER TABLE `lnloantypmoreshrereqgrt` DROP INDEX `SYS_C0015150`;
ALTER TABLE `lnloantypmoreshrereqgrt` ADD INDEX `SYS_C0015150` (`COOP_ID`, `LOANTYPE_CODE`, `SEQ_NO`);

ALTER TABLE `lnmembpauseloan` DROP INDEX `SYS_C0043786`;
ALTER TABLE `lnmembpauseloan` ADD INDEX `SYS_C0043786` (`COOP_ID`, `MEMBER_NO`, `LOANTYPE_CODE`);

ALTER TABLE `lnnpltracking` DROP INDEX `SYS_C0056197`;
ALTER TABLE `lnnpltracking` ADD INDEX `SYS_C0056197` (`COOP_ID`, `TRACKING_NO`) ;

ALTER TABLE `lnnpltrackingmeeting` DROP INDEX `SYS_C0056198`;
ALTER TABLE `lnnpltrackingmeeting` ADD INDEX `SYS_C0056198` (`COOP_ID`, `TRACKING_NO`, `SEQ_NO`);

ALTER TABLE `lnnpltrackingtodolist` DROP INDEX `SYS_C0056199`;
ALTER TABLE `lnnpltrackingtodolist` ADD INDEX `SYS_C0056199` (`COOP_ID`, `TRACKING_NO`, `SEQ_NO`);

ALTER TABLE `lnpreparepay` DROP INDEX `XPKLNC`;
ALTER TABLE `lnpreparepay` ADD INDEX `XPKLNC` (`COOP_ID`, `LOANCONTRACT_NO`, `SEQ_NO`);

ALTER TABLE `lnreqchgcontlaw` DROP INDEX `SYS_C0015167`;
ALTER TABLE `lnreqchgcontlaw` ADD INDEX `SYS_C0015167` (`COOP_ID`, `LNCHGCONTLAW_DOCNO`);

 ALTER TABLE `lnreqchgcontlawcoll` DROP INDEX `SYS_C0015172`;
ALTER TABLE `lnreqchgcontlawcoll` ADD INDEX `SYS_C0015172` (`COOP_ID`, `LNCHGCONTLAW_DOCNO`, `TRN_CONTRACTNO`);

ALTER TABLE `lnreqcollmastredeem` DROP INDEX `XPKLNREQCOLLMASTREDEEM`;
ALTER TABLE `lnreqcollmastredeem` ADD INDEX `XPKLNREQCOLLMASTREDEEM` (`COOP_ID`, `REDEEM_DOCNO`);

ALTER TABLE `lnreqcontadjustintspc` DROP INDEX `PK_LNREQCONTADJUSTINTSPC`;
ALTER TABLE `lnreqcontadjustintspc` ADD INDEX `PK_LNREQCONTADJUSTINTSPC` (`COOP_ID`, `CONTADJUST_DOCNO`, `CONTADJUST_TYPE`, `SEQ_NO`);

ALTER TABLE `lnreqloan` DROP INDEX `XIE1LNREQLOAN`;
ALTER TABLE `lnreqloan` ADD INDEX `XIE1LNREQLOAN` (`MEMBER_NO`);
ALTER TABLE `lnreqloan` DROP INDEX `XIE4LNREQLOAN`;
ALTER TABLE `lnreqloan` ADD INDEX `XIE4LNREQLOAN` (`LOANCONTRACT_NO`);
ALTER TABLE `lnreqloan` DROP INDEX `XIE3LNREQLOAN`;
ALTER TABLE `lnreqloan` ADD INDEX `XIE3LNREQLOAN` (`LOANREQUEST_DATE`);
ALTER TABLE `lnreqloan` DROP INDEX `XIE2LNREQLOAN`;
ALTER TABLE `lnreqloan` ADD INDEX `XIE2LNREQLOAN` (`LOANTYPE_CODE`);

ALTER TABLE `lnreqloanclr` DROP INDEX `XIE1LNREQLOANCLR`;
ALTER TABLE `lnreqloanclr` ADD INDEX `XIE1LNREQLOANCLR` (`LOANTYPE_CODE`);

ALTER TABLE `lnreqloanclrother` DROP INDEX `XPKLNREQLOANCLROTHER`;
ALTER TABLE `lnreqloanclrother` ADD INDEX `XPKLNREQLOANCLROTHER` (`COOP_ID`, `LOANREQUEST_DOCNO`, `SEQ_NO`);

ALTER TABLE `lnreqloanintspc` DROP INDEX `PK009999`;
ALTER TABLE `lnreqloanintspc` ADD INDEX `PK009999` (`LOANREQUEST_DOCNO`, `SEQ_NO`, `COOP_ID`);

ALTER TABLE `lnreqloanmthexp` DROP INDEX `XPKLNREQLOANMTHEXP`;
ALTER TABLE `lnreqloanmthexp` ADD INDEX `XPKLNREQLOANMTHEXP` (`COOP_ID`, `LOANREQUEST_DOCNO`, `SEQ_NO`);

 ALTER TABLE `lnreqloanperiodpaydet` DROP INDEX `SYS33333WEE`;
 ALTER TABLE `lnreqloanperiodpaydet` ADD INDEX `SYS33333WEE` (`LOANREQUEST_DOCNO`, `COOP_ID`, `PERIOD`);
 
 ALTER TABLE `lnreqloanregister` DROP INDEX `SYS_C0015219`;
 ALTER TABLE `lnreqloanregister` ADD INDEX `SYS_C0015219` (`COOP_ID`, `REQREGISTER_DOCNO`);
 
 ALTER TABLE `lnreqpauseloan` DROP INDEX `XPKLNREQPAUSELOAN`;
 ALTER TABLE `lnreqpauseloan` ADD INDEX `XPKLNREQPAUSELOAN` (`COOP_ID`, `PAUSELOAN_DOCNO`);
 
ALTER TABLE `lnreqpauseloandet` DROP INDEX `XPKLNREQPAUSELOANDET`;
ALTER TABLE `lnreqpauseloandet` ADD INDEX `XPKLNREQPAUSELOANDET` (`COOP_ID`, `PAUSELOAN_DOCNO`, `LOANTYPE_CODE`);

ALTER TABLE `lnreqtrnloncoll` DROP INDEX `SYS_C0043891`;
ALTER TABLE `lnreqtrnloncoll` ADD INDEX `SYS_C0043891` (`COOP_ID`, `TRNCOLLREQ_DOCNO`);

ALTER TABLE `lnreqtrnloncolldet` DROP INDEX `SYS_C0043897`;
ALTER TABLE `lnreqtrnloncolldet` ADD INDEX `SYS_C0043897` (`COOP_ID`, `TRNCOLLREQ_DOCNO`, `TRN_CONTRACTNO`);

ALTER TABLE `lnsetintarr` DROP INDEX `SYS_C0015262`;
ALTER TABLE `lnsetintarr` ADD INDEX `SYS_C0015262` (`SETINTARR_DOCNO`);

ALTER TABLE `lnsetintarrdet` DROP INDEX `SYS_C0015265`;
ALTER TABLE `lnsetintarrdet` ADD INDEX `SYS_C0015265` (`SETINTARR_DOCNO`, `LOANCONTRACT_NO`) ;

ALTER TABLE `lnsetintarryear` DROP INDEX `SYS_C0015270`;
ALTER TABLE `lnsetintarryear` ADD INDEX `SYS_C0015270` (`COOP_ID`, `ACCOUNT_YEAR`, `ACCOUNT_MONTH`, `LOANCONTRACT_NO`);

ALTER TABLE `lntablemeeting` DROP INDEX `SYS_C0015273`;
ALTER TABLE `lntablemeeting` ADD INDEX `SYS_C0015273` (`LOANTYPE_CODE`, `LNREQRECEIVE_DATE`);

ALTER TABLE `lnucfcollprintset` DROP INDEX `LNUCFCOLLPRINTSET_X`;
ALTER TABLE `lnucfcollprintset` ADD INDEX `LNUCFCOLLPRINTSET_X` (`COLLMASTTYPE_CODE`, `PRINTSET_CODE`, `DOC_ID`);

ALTER TABLE `lnucfcontcclcause` DROP INDEX `XPKLNUCFCONTCCLCAUSE`;
ALTER TABLE `lnucfcontcclcause` ADD INDEX `XPKLNUCFCONTCCLCAUSE` (`COOP_ID`, `CONTCCLCAUSE_CODE`);

ALTER TABLE `lnucfloancolltype` DROP INDEX `SYS_C0055798`;
ALTER TABLE `lnucfloancolltype` ADD INDEX `SYS_C0055798` (`LOANCOLLTYPE_CODE`);

ALTER TABLE `lnucfloanobjective` DROP INDEX `PK_4333E3333`;
ALTER TABLE `lnucfloanobjective` ADD INDEX `PK_4333E3333` (`LOANOBJECTIVE_DESC`, `COOP_ID`, `LOANTYPE_CODE`);

ALTER TABLE `lnucfloanpaytype` DROP INDEX `EWE32323`;
ALTER TABLE `lnucfloanpaytype` ADD INDEX `EWE32323` (`LOANPAYTYPE_CODE`);

ALTER TABLE `lnucfnplcommitteecode` DROP INDEX `SYS_C0056200`;
ALTER TABLE `lnucfnplcommitteecode` ADD INDEX `SYS_C0056200` (`COMMITTEE_CODE`);

ALTER TABLE `loan` DROP INDEX `LOAN_X`;
ALTER TABLE `loan` ADD INDEX `LOAN_X` (`COOP_ID`, `LOAN_ID`);

ALTER TABLE `lsgrpmangrtpermdet` DROP INDEX `LNGRPMANGRTPERMDET_X`;
ALTER TABLE `lsgrpmangrtpermdet` ADD INDEX `LNGRPMANGRTPERMDET_X` (`MANGRTPERMGRP_CODE`, `SEQ_NO`);

ALTER TABLE `mbadjsalarytemp` DROP INDEX `SYS_C0056216`;
ALTER TABLE `mbadjsalarytemp` ADD INDEX `SYS_C0056216` (`COOP_ID`, `SALARY_ID`);

ALTER TABLE `mbconstant` DROP INDEX `SYS_C0056098`;
ALTER TABLE `mbconstant` ADD INDEX `SYS_C0056098` (`COOP_ID`, `MEMBER_TYPE`);

ALTER TABLE `mbgainmaster` DROP INDEX `XPKMBGAINMASTER`;
ALTER TABLE `mbgainmaster` ADD INDEX `XPKMBGAINMASTER` (`COOP_ID`, `MEMBER_NO`, `SEQ_NO`);

ALTER TABLE `mbmembcard` DROP INDEX `SYS_C0015523`;
ALTER TABLE `mbmembcard` ADD INDEX `SYS_C0015523` (`MEMBER_NO`);

ALTER TABLE `mbmembmaster` DROP INDEX `INDX_SALARYID`;
ALTER TABLE `mbmembmaster` ADD INDEX `INDX_SALARYID` (`SALARY_ID`, `MEMBER_NO`);

ALTER TABLE `mbmembmthexpense` DROP INDEX `SYS_C0020411`;
ALTER TABLE `mbmembmthexpense` ADD INDEX `SYS_C0020411` (`COOP_ID`, `MEMBER_NO`, `SEQ_NO`);
ALTER TABLE `mbmembmthexpense` DROP INDEX `SYS_C0055848`;
ALTER TABLE `mbmembmthexpense` ADD INDEX `SYS_C0055848` (`COOP_ID`, `MEMBER_NO`, `SIGN_FLAG`, `SEQ_NO`);

ALTER TABLE `mbmembremarkstat` DROP INDEX `SYS_C0026088`;
ALTER TABLE `mbmembremarkstat` ADD INDEX `SYS_C0026088` (`COOP_ID`, `MEMBER_NO`, `REMARKSTATTYPE_CODE`);

ALTER TABLE `mbmemclose` DROP INDEX `SYS_C0015551`;
ALTER TABLE `mbmemclose` ADD INDEX `SYS_C0015551` (`MEMCLOSE_DOCNO`);

ALTER TABLE `mbreqappl` DROP INDEX `SYS_C0044201`;
ALTER TABLE `mbreqappl` ADD INDEX `SYS_C0044201` (`COOP_ID`, `APPL_DOCNO`);

ALTER TABLE `mbreqappl` DROP INDEX `XIF92MBREQAPPL`;
ALTER TABLE `mbreqappl` ADD INDEX `XIF92MBREQAPPL` (`POSITION_CODE`);

ALTER TABLE `mbreqappl` DROP INDEX `XIF91MBREQAPPL`;
ALTER TABLE `mbreqappl` ADD INDEX `XIF91MBREQAPPL` (`MEMBGROUP_CODE`);

ALTER TABLE `mbreqappl` DROP INDEX `XIF93MBREQAPPL`;
ALTER TABLE `mbreqappl` ADD INDEX `XIF93MBREQAPPL` (`DEPARTMENT_CODE`);

ALTER TABLE `mbreqappl` DROP INDEX `XIF269MBREQAPPL`;
ALTER TABLE `mbreqappl` ADD INDEX `XIF269MBREQAPPL` (`RESIGNCAUSE_CODE`);

ALTER TABLE `mbreqapplgain` DROP INDEX `XPKMBREQAPPLGAIN`;
ALTER TABLE `mbreqapplgain` ADD INDEX `XPKMBREQAPPLGAIN` (`COOP_ID`, `APPL_DOCNO`, `SEQ_NO`);

ALTER TABLE `mbreqapplmoneytr` DROP INDEX `XPKMBREQAPPLMONEYTR`;
ALTER TABLE `mbreqapplmoneytr` ADD INDEX `XPKMBREQAPPLMONEYTR` (`COOP_ID`, `APPL_DOCNO`, `TRTYPE_CODE`);

ALTER TABLE `mbreqchangegroup` DROP INDEX `SYS_C0044223`;
ALTER TABLE `mbreqchangegroup` ADD INDEX `SYS_C0044223` (`COOP_ID`, `CHGGROUP_DOCNO`);

ALTER TABLE `mbreqchgmthpaystatus` DROP INDEX `SYS_C0015586`;
ALTER TABLE `mbreqchgmthpaystatus` ADD INDEX `SYS_C0015586` (`COOP_ID`, `CHGMTHPAY_DOCNO`);

ALTER TABLE `mbreqchgmthpaystatusdet` DROP INDEX `SYS_C0015591`;
ALTER TABLE `mbreqchgmthpaystatusdet` ADD INDEX `SYS_C0015591` (`COOP_ID`, `CHGMTHPAY_DOCNO`, `CHGMTHPAY_TYPE`, `SEQ_NO`);

ALTER TABLE `mbreqgaindetail` DROP INDEX `XPKMBREQGAINDETAIL`;
ALTER TABLE `mbreqgaindetail` ADD INDEX `XPKMBREQGAINDETAIL` (`COOP_ID`, `GAIN_DOCNO`, `GAIN_CHGTYPE`, `SEQ_NO`);

ALTER TABLE `mbreqresignloan` DROP INDEX `XIF81MBREQRESIGNLOAN`;
ALTER TABLE `mbreqresignloan` ADD INDEX `XIF81MBREQRESIGNLOAN` (`LOANTYPE_CODE`);

ALTER TABLE `mbucfdistrict` DROP INDEX `XPKMBUCFDISTRICT`;
ALTER TABLE `mbucfdistrict` ADD INDEX `XPKMBUCFDISTRICT` (`DISTRICT_CODE`);

ALTER TABLE `mbucfdistrict_trn` DROP INDEX `MBUCFDISTRICT_TRN`;
ALTER TABLE `mbucfdistrict_trn` ADD INDEX `MBUCFDISTRICT_TRN` (`DISTRICT_CODE`, `PROVINCE_CODE`);

ALTER TABLE `mbucfexpensetype` DROP INDEX `SYS_C0015646`;
ALTER TABLE `mbucfexpensetype` ADD INDEX `SYS_C0015646` (`EXPENSE_CODE`);

ALTER TABLE `mbucfmembgroup` DROP INDEX `MBUCFMEMBGROUP_X`;
ALTER TABLE `mbucfmembgroup` ADD INDEX `MBUCFMEMBGROUP_X` (`COOP_ID`, `MEMBGROUP_CODE`);

ALTER TABLE `mbucfmembgroupcontrol` DROP INDEX `MBUCFMEMBGROUPCONTROL_X`;
ALTER TABLE `mbucfmembgroupcontrol` ADD INDEX `MBUCFMEMBGROUPCONTROL_X` (`COOP_ID`, `MEMBGROUP_CONTROL`);

ALTER TABLE `mbucfmembgroupgsb` DROP INDEX `MBUCFMEMBGROUPGSB_X`;
ALTER TABLE `mbucfmembgroupgsb` ADD INDEX `MBUCFMEMBGROUPGSB_X` (`MEMBGROUP_CODE`, `MEMBGROUP_CTRL`, `SALARY_ID`);
 
ALTER TABLE `mbucfpostcode` DROP INDEX `MBUCFPOSTCODE_X`;
ALTER TABLE `mbucfpostcode` ADD INDEX `MBUCFPOSTCODE_X` (`POSTCODE_NO`);
 
ALTER TABLE `mbucfprovince` DROP INDEX `XPKMBUCFPROVINCE`;
ALTER TABLE `mbucfprovince` ADD INDEX `XPKMBUCFPROVINCE` (`PROVINCE_CODE`);
 
ALTER TABLE `mbucfreturnccl` DROP INDEX `SYS_C0015687`;
ALTER TABLE `mbucfreturnccl` ADD INDEX `SYS_C0015687` (`RETURNCCL_CODE`);
 
ALTER TABLE `mbucfsalaryrate` DROP INDEX `SYS_C0015692`;
ALTER TABLE `mbucfsalaryrate` ADD INDEX `SYS_C0015692` (`LEVEL_CODE`, `STEP_CODE`);
 
ALTER TABLE `mbucftambol` DROP INDEX `XPKMBUCFTAMBOL`;
ALTER TABLE `mbucftambol` ADD INDEX `XPKMBUCFTAMBOL` (`TAMBOL_CODE`);
 
ALTER TABLE `mbyeardetail` DROP INDEX `SYS_C0015698`;
ALTER TABLE `mbyeardetail` ADD INDEX `SYS_C0015698` (`MEMBER_NO`, `COOP_ID`, `ACC_YEAR`);
 
ALTER TABLE `messages` DROP INDEX `SYS_C0015701`;
ALTER TABLE `messages` ADD INDEX `SYS_C0015701` (`MSGID`);
  
ALTER TABLE `mgcfconstant` DROP INDEX `XPKMGCFCONSTANT`;
ALTER TABLE `mgcfconstant` ADD INDEX `XPKMGCFCONSTANT` (`COOP_NO`);

ALTER TABLE `mgcfmrtgprintset` DROP INDEX `XPKMGCFMRTGPRINTSET`;
ALTER TABLE `mgcfmrtgprintset` ADD INDEX `XPKMGCFMRTGPRINTSET` (`ASSETTYPE_CODE`, `PRINTSET_CODE`, `DOC_ID`);

ALTER TABLE `mgmrtgmaster` DROP INDEX `PK_MGMRTGMASTER`;
ALTER TABLE `mgmrtgmaster` ADD INDEX `PK_MGMRTGMASTER` (`MRTGMAST_NO`);

ALTER TABLE `mgmrtgmastupgrade` DROP INDEX `SYS_C0015712`;
ALTER TABLE `mgmrtgmastupgrade` ADD INDEX `SYS_C0015712` (`MRTGMAST_NO`, `UPGRADE_NO`);

ALTER TABLE `mgmrtgreflncollmast` DROP INDEX `SYS_C0015715`;
ALTER TABLE `mgmrtgreflncollmast` ADD INDEX `SYS_C0015715` (`MRTGMAST_NO`, `COLLMAST_NO`);

ALTER TABLE `mgtemplateautzd` DROP INDEX `XPKMGTEMPLATEAUTZD`;
ALTER TABLE `mgtemplateautzd` ADD INDEX `XPKMGTEMPLATEAUTZD` (`TEMPLATE_NO`);

ALTER TABLE `mgtemplatecommitee` DROP INDEX `XPKMGTEMPLATECOMMITEE`;
ALTER TABLE `mgtemplatecommitee` ADD INDEX `XPKMGTEMPLATECOMMITEE` (`COMMITEE_NO`);

ALTER TABLE `mgucfassettype` DROP INDEX `XPKMGUCFASSETTYPE`;
ALTER TABLE `mgucfassettype` ADD INDEX `XPKMGUCFASSETTYPE` (`ASSETTYPE_CODE`);

ALTER TABLE `misratio` DROP INDEX `XPKMISRATIO`;
ALTER TABLE `misratio` ADD INDEX `XPKMISRATIO` (`RATIO_ID`);

ALTER TABLE `misratiogroup` DROP INDEX `XPKMISRATIOGROUP`;
ALTER TABLE `misratiogroup` ADD INDEX `XPKMISRATIOGROUP` (`RATGROUP_ID`);

ALTER TABLE `misratiooperand` DROP INDEX `SYS_C0015728`;
ALTER TABLE `misratiooperand` ADD INDEX `SYS_C0015728` (`RATIO_ID`, `RATVAR_SEQ`);

ALTER TABLE `misratiotest` DROP INDEX `SYS_C0015731`;
ALTER TABLE `misratiotest` ADD INDEX `SYS_C0015731` (`RATTEST_ID`);

ALTER TABLE `misratiotestvalue` DROP INDEX `SYS_C0015734`;
ALTER TABLE `misratiotestvalue` ADD INDEX `SYS_C0015734` (`RATTEST_ID`, `RATVAR_SEQ`);

ALTER TABLE `misratiovar` DROP INDEX `XPKMISRATIOVAR`;
ALTER TABLE `misratiovar` ADD INDEX `XPKMISRATIOVAR` (`RATVAR_ID`);

ALTER TABLE `month_receipt` DROP INDEX `MONTH_RECEIPT_X`;
ALTER TABLE `month_receipt` ADD INDEX `MONTH_RECEIPT_X` (`COOP_ID`, `MEMBER_ID`, `RECEIPT_DATE`);

ALTER TABLE `month_receipt_detail` DROP INDEX `MONTH_RECEIPT_DETAIL_X`;
ALTER TABLE `month_receipt_detail` ADD INDEX `MONTH_RECEIPT_DETAIL_X` (`COOP_ID`, `MEMBER_ID`, `RECEIPT_DATE`, `T_RECEIPT_TYPE`, `T_TYPE`, `SEQ`);

ALTER TABLE `paprintingdetail` DROP INDEX `SYS_C0074429`;
ALTER TABLE `paprintingdetail` ADD INDEX `SYS_C0074429` (`PRINTING_NAME`, `POSITION`, `COLUMN_NAME`);

ALTER TABLE `pmshortlong` DROP INDEX `IDX_YEAR_SETTING`;
ALTER TABLE `pmshortlong` ADD INDEX `IDX_YEAR_SETTING` (`YEAR_SETTING`);

ALTER TABLE `projectconfig` DROP INDEX `SYS_C0015892`;
ALTER TABLE `projectconfig` ADD INDEX `SYS_C0015892` (`CFG_REQ`);

ALTER TABLE `projectinvite` DROP INDEX `SYS_C0055950`;
ALTER TABLE `projectinvite` ADD INDEX `SYS_C0055950` (`INVITE_TYPE`, `INVITE_SEQ`);

ALTER TABLE `ptnmlcatalogdea` DROP INDEX `SYS_C0010948`;
ALTER TABLE `ptnmlcatalogdea` ADD INDEX `SYS_C0010948` (`SEQ_NO`);

ALTER TABLE `ptnmlcustomermas` DROP INDEX `SYS_C0010950`;
ALTER TABLE `ptnmlcustomermas` ADD INDEX `SYS_C0010950` (`PARNER_ID`);

ALTER TABLE `ptnmldisoffdea` DROP INDEX `SYS_C0015974`;
ALTER TABLE `ptnmldisoffdea` ADD INDEX `SYS_C0015974` (`SEQ_DISOFF`, `DISOFF_ID`);

ALTER TABLE `ptnmldomain` DROP INDEX `SYS_C005661`;
ALTER TABLE `ptnmldomain` ADD INDEX `SYS_C005661` (`DOMAIN_ID`, `ITEMTYPE_ID`);

ALTER TABLE `ptnmlgroup` DROP INDEX `SYS_C15455`;
ALTER TABLE `ptnmlgroup` ADD INDEX `SYS_C15455` (`DOMAIN_ID`, `GROUP_ID`, `ITEMTYPE_ID`);

ALTER TABLE `ptnmlitemcreatemas` DROP INDEX `SYS_C0024840`;
ALTER TABLE `ptnmlitemcreatemas` ADD INDEX `SYS_C0024840` (`COOP_ID`, `CREATE_ID`);

ALTER TABLE `ptnmlstockmas` DROP INDEX `SYS_C0010989`;
ALTER TABLE `ptnmlstockmas` ADD INDEX `SYS_C0010989` (`PRODUCT_ID`, `COOP_ID`);

ALTER TABLE `ptnmlsubgroup` DROP INDEX `SYS_C0011000`;
ALTER TABLE `ptnmlsubgroup` ADD INDEX `SYS_C0011000` (`DOMAIN_ID`, `GROUP_ID`, `SUBGROUP_ID`, `ITEMTYPE_ID`, `COOP_ID`, `OWNER`);

ALTER TABLE `ptslpslipdea` DROP INDEX `SYS_C0011008`;
ALTER TABLE `ptslpslipdea` ADD INDEX `SYS_C0011008` (`SEQ_NO`, `SLIP_ID`);

ALTER TABLE `ptucdsliptype` DROP INDEX `SYS_C0011012`;
ALTER TABLE `ptucdsliptype` ADD INDEX `SYS_C0011012` (`SLIPTYPE_ID`);

ALTER TABLE `ptucfbranch` DROP INDEX `SYS_C0011020`;
ALTER TABLE `ptucfbranch` ADD INDEX `SYS_C0011020` (`BRANCH_ID`);

ALTER TABLE `ptucfitemtype` DROP INDEX `SYS_C0011024`;
ALTER TABLE `ptucfitemtype` ADD INDEX `SYS_C0011024` (`ITEMTYPE_ID`);

ALTER TABLE `ptucfproductunit` DROP INDEX `SYS_C0011034`;
ALTER TABLE `ptucfproductunit` ADD INDEX `SYS_C0011034` (`UNIT_ID`);

ALTER TABLE `ptucfstageuse` DROP INDEX `SYS_C0011036`;
ALTER TABLE `ptucfstageuse` ADD INDEX `SYS_C0011036` (`STAGEUSE_ID`);

ALTER TABLE `ptucfstatusdel` DROP INDEX `SYS_C0011038`;
ALTER TABLE `ptucfstatusdel` ADD INDEX `SYS_C0011038` (`DEL_ID`);

ALTER TABLE `scandocconstant` DROP INDEX `SYS_C008589`;
ALTER TABLE `scandocconstant` ADD INDEX `SYS_C008589` (`COOP_NO`);

ALTER TABLE `scandocfordept` DROP INDEX `SYS_C0016064`;
ALTER TABLE `scandocfordept` ADD INDEX `SYS_C0016064` (`DOC_ID`, `SEQ_NO`, `DEPTACCOUNT_NO`, `DOCTYPE_CODE`);

ALTER TABLE `shpaymentadjust` DROP INDEX `SYS_C0055992`;
ALTER TABLE `shpaymentadjust` ADD UNIQUE `SYS_C0055992` (`COOP_ID`, `PAYADJUST_DOCNO`);

ALTER TABLE `shsharegift` DROP INDEX `XPKSHSHAREGIFT`;
ALTER TABLE `shsharegift` ADD INDEX `XPKSHSHAREGIFT` (`SHRGIFT_YEAR`, `SHRGIFT_PERIOD`, `MEMBER_NO`);
ALTER TABLE `shsharegift` DROP INDEX `XIE1SHSHAREGIFT`;
ALTER TABLE `shsharegift` ADD INDEX `XIE1SHSHAREGIFT` (`MEMBGROUP_CODE`);

ALTER TABLE `shsharestatement` DROP INDEX `SHSHARESTATEMENTSLIPDATE`;
ALTER TABLE `shsharestatement` ADD INDEX `SHSHARESTATEMENTSLIPDATE` (`SLIP_DATE`);
ALTER TABLE `shsharestatement` DROP INDEX `IDX_SHSTMACCDATE`;
ALTER TABLE `shsharestatement` ADD INDEX `IDX_SHSTMACCDATE` (`ACCOUNT_DATE`);
ALTER TABLE `shsharestatement` DROP INDEX `XIE2SHSHARESTATEMENT`;
ALTER TABLE `shsharestatement` ADD INDEX `XIE2SHSHARESTATEMENT` (`OPERATE_DATE`);
ALTER TABLE `shsharestatement` DROP INDEX `XIE1SHSHARESTATEMENT`;
ALTER TABLE `shsharestatement` ADD INDEX `XIE1SHSHARESTATEMENT` (`REF_DOCNO`);
ALTER TABLE `shsharestatement` DROP INDEX `SYS_C00236868`;
ALTER TABLE `shsharestatement` ADD UNIQUE `SYS_C00236868` (`COOP_ID`, `MEMBER_NO`, `SEQ_NO`);
ALTER TABLE `shsharestatement` DROP INDEX `SYS_C0055995`;
ALTER TABLE `shsharestatement` ADD UNIQUE `SYS_C0055995` (`COOP_ID`, `MEMBER_NO`, `SHARETYPE_CODE`, `SEQ_NO`);

ALTER TABLE `slclsmthbalance` DROP INDEX `XINX_SLCLSMTH_DEL`;
ALTER TABLE `slclsmthbalance` ADD INDEX `XINX_SLCLSMTH_DEL` (`COOP_ID`, `CLSMTH_PERIOD`, `BIZZ_SYSTEM`);

ALTER TABLE `slorderpayin` DROP INDEX `SYS_C0016181`;
ALTER TABLE `slorderpayin` ADD UNIQUE `SYS_C0016181` (`COOP_ID`, `PAYINORDER_NO`);

ALTER TABLE `slorderpayindet` DROP INDEX `SYS_C0016186`;
ALTER TABLE `slorderpayindet` ADD UNIQUE `SYS_C0016186` (`COOP_ID`, `PAYINORDER_NO`, `SLIPITEMTYPE_CODE`, `SEQ_NO`);

ALTER TABLE `slorderpayinexpense` DROP INDEX `SYS_C0016190`;
ALTER TABLE `slorderpayinexpense` ADD UNIQUE `SYS_C0016190` (`COOP_ID`, `PAYINORDER_NO`, `SEQ_NO`);

ALTER TABLE `slorderpayout` DROP INDEX `SYS_C0016193`;
ALTER TABLE `slorderpayout` ADD UNIQUE `SYS_C0016193` (`COOP_ID`, `PAYOUTORDER_NO`);

ALTER TABLE `slorderpayoutdet` DROP INDEX `SYS_C0016203`;
ALTER TABLE `slorderpayoutdet` ADD UNIQUE `SYS_C0016203` (`COOP_ID`, `PAYOUTORDER_NO`, `SLIPITEMTYPE_CODE`, `SEQ_NO`);

ALTER TABLE `slorderpayoutexpense` DROP INDEX `SYS_C0016207`;
ALTER TABLE `slorderpayoutexpense` ADD UNIQUE `SYS_C0016207` (`COOP_ID`, `PAYOUTORDER_NO`, `SEQ_NO`);

ALTER TABLE `slorderpayouttrncoll` DROP INDEX `SYS_C0016212`;
ALTER TABLE `slorderpayouttrncoll` ADD UNIQUE `SYS_C0016212` (`COOP_ID`, `PAYOUTORDER_NO`, `LOANCONTRACT_NO`, `REF_COLLNO`);

ALTER TABLE `slreqcompound` DROP INDEX `SYS_C0016215`;
ALTER TABLE `slreqcompound` ADD UNIQUE `SYS_C0016215` (`COOP_ID`, `REQCOMP_DOCNO`);

ALTER TABLE `slreqcompounddet` DROP INDEX `SYS_C0016220`;
ALTER TABLE `slreqcompounddet` ADD UNIQUE `SYS_C0016220` (`COOP_ID`, `REQCOMP_DOCNO`, `REQCOMPTYPE_CODE`, `SEQ_NO`);

ALTER TABLE `slslipadjust` DROP INDEX `XPKSLSLIPADJUST`;
ALTER TABLE `slslipadjust` ADD UNIQUE `XPKSLSLIPADJUST` (`COOP_ID`, `ADJSLIP_NO`);

ALTER TABLE `slslipadjustdet` DROP INDEX `XPKSLSLIPADJUSTDET`;
ALTER TABLE `slslipadjustdet` ADD UNIQUE `XPKSLSLIPADJUSTDET` (`COOP_ID`, `ADJSLIP_NO`, `SLIPITEMTYPE_CODE`, `SEQ_NO`);

ALTER TABLE `slslippayin` DROP INDEX `XPKSLSLIPPAYIN`;
ALTER TABLE `slslippayin` ADD UNIQUE `XPKSLSLIPPAYIN` (`COOP_ID`, `PAYINSLIP_NO`);

ALTER TABLE `slslippayindet` DROP INDEX `XIE1SLSLIPPAYINDET`;
ALTER TABLE `slslippayindet` ADD INDEX `XIE1SLSLIPPAYINDET` (`LOANCONTRACT_NO`);
ALTER TABLE `slslippayindet` DROP INDEX `XPKSLSLIPPAYINDET`;
ALTER TABLE `slslippayindet` ADD UNIQUE `XPKSLSLIPPAYINDET` (`COOP_ID`, `PAYINSLIP_NO`, `SLIPITEMTYPE_CODE`, `SEQ_NO`);

ALTER TABLE `slslippayinexpense` DROP INDEX `SYS_C0016240`;
ALTER TABLE `slslippayinexpense` ADD UNIQUE `SYS_C0016240` (`COOP_ID`, `PAYINSLIP_NO`, `SEQ_NO`);

ALTER TABLE `slslippayout` DROP INDEX `XIE5SLSLIPPAYOUT`;
ALTER TABLE `slslippayout` ADD INDEX `XIE5SLSLIPPAYOUT` (`OPERATE_DATE`);
ALTER TABLE `slslippayout` DROP INDEX `XIE4SLSLIPPAYOUT`;
ALTER TABLE `slslippayout` ADD INDEX `XIE4SLSLIPPAYOUT` (`SLIPCLEAR_NO`);
ALTER TABLE `slslippayout` DROP INDEX `XIE2SLSLIPPAYOUT`;
ALTER TABLE `slslippayout` ADD INDEX `XIE2SLSLIPPAYOUT` (`SLIP_DATE`);
ALTER TABLE `slslippayout` DROP INDEX `XIE1SLSLIPPAYOUT`;
ALTER TABLE `slslippayout` ADD INDEX `XIE1SLSLIPPAYOUT` (`MEMBER_NO`);
ALTER TABLE `slslippayout` DROP INDEX `XPKSLSLIPPAYOUT`;
ALTER TABLE `slslippayout` ADD INDEX `XPKSLSLIPPAYOUT` (`COOP_ID`, `PAYOUTSLIP_NO`);

ALTER TABLE `slslippayoutdet` DROP INDEX `SYS_C0044973`;
ALTER TABLE `slslippayoutdet` ADD INDEX `SYS_C0044973` (`COOP_ID`, `PAYOUTSLIP_NO`, `SLIPITEMTYPE_CODE`, `SEQ_NO`);

ALTER TABLE `sltranspayin` DROP INDEX `XPKSLTRANSPAYIN`;
ALTER TABLE `sltranspayin` ADD INDEX `XPKSLTRANSPAYIN` (`COOP_ID`, `MEMCOOP_ID`, `MEMBER_NO`, `TRANS_DATE`, `SEQ_NO`);

ALTER TABLE `slucfslipadjtype` DROP INDEX `XPKSLUCFSLIPADJTYPE`;
ALTER TABLE `slucfslipadjtype` ADD INDEX `XPKSLUCFSLIPADJTYPE` (`COOP_ID`, `ADJTYPE_CODE`);

ALTER TABLE `slucfslipreturncause` DROP INDEX `XPKSLUCFSLIPRETURNCAUSE`;
ALTER TABLE `slucfslipreturncause` ADD INDEX `XPKSLUCFSLIPRETURNCAUSE` (`COOP_ID`, `SLIPRETCAUSE_CODE`);

ALTER TABLE `snp_month_balance` DROP INDEX `SNP_MONTH_BALANCE_COPY_X`;
ALTER TABLE `snp_month_balance` ADD INDEX `SNP_MONTH_BALANCE_COPY_X` (`COOP_ID`, `MEMBER_ID`, `BUDGET_YEAR`, `MONTHS`);

ALTER TABLE `snp_month_balance_detail` DROP INDEX `SNP_MONTH_BALANCE_DETAIL_COPY_`;
ALTER TABLE `snp_month_balance_detail` ADD INDEX `SNP_MONTH_BALANCE_DETAIL_COPY_` (`COOP_ID`, `MEMBER_ID`, `BUDGET_YEAR`, `MONTHS`, `T_RECEIPT_TYPE`, `T_TYPE`, `SEQ`);

ALTER TABLE `snp_month_receipt` DROP INDEX `SNP_MONTH_RECEIPT_X`;
ALTER TABLE `snp_month_receipt` ADD INDEX `SNP_MONTH_RECEIPT_X` (`COOP_ID`, `MEMBER_ID`, `RECEIPT_DATE`);

ALTER TABLE `snp_month_receipt_detail` DROP INDEX `SNP_MONTH_RECEIPT_DETAIL_X`;
ALTER TABLE `snp_month_receipt_detail` ADD INDEX `SNP_MONTH_RECEIPT_DETAIL_X` (`COOP_ID`, `MEMBER_ID`, `RECEIPT_DATE`, `T_RECEIPT_TYPE`, `T_TYPE`, `SEQ`);

ALTER TABLE `sys_apporve_docctrl` DROP INDEX `PK_SYS_APPORVE_DOCTRL`;
ALTER TABLE `sys_apporve_docctrl` ADD INDEX `PK_SYS_APPORVE_DOCTRL` (`C_PROCESSID`);

ALTER TABLE `t_amphur` DROP INDEX `T_AMPHUR_X`;
ALTER TABLE `t_amphur` ADD INDEX `T_AMPHUR_X` (`AMPHUR_ID`);

ALTER TABLE `t_district` DROP INDEX `T_DISTRICT_X`;
ALTER TABLE `t_district` ADD INDEX `T_DISTRICT_X` (`DISTRICT_ID`);

ALTER TABLE `t_geography` DROP INDEX `T_GEOGRAPHY_X`;
ALTER TABLE `t_geography` ADD INDEX `T_GEOGRAPHY_X` (`GEO_ID`);

ALTER TABLE `t_interest` DROP INDEX `T_INTEREST_COPY_X`;
ALTER TABLE `t_interest` ADD INDEX `T_INTEREST_COPY_X` (`COOP_ID`, `T_TYPE`, `T_INT`, `FIRST_EFFECT_DATE`);

ALTER TABLE `t_province` DROP INDEX `T_PROVINCE_X`;
ALTER TABLE `t_province` ADD INDEX `T_PROVINCE_X` (`PROVINCE_ID`);

ALTER TABLE `t_route_group` DROP INDEX `T_ROUTE_GROUP_X`;
ALTER TABLE `t_route_group` ADD INDEX `T_ROUTE_GROUP_X` (`COOP_ID`, `T_ROUTE_GROUP`);

ALTER TABLE `t_zipcode` DROP INDEX `T_ZIPCODE_X`;
ALTER TABLE `t_zipcode` ADD INDEX `T_ZIPCODE_X` (`ZIPCODE_ID`);

ALTER TABLE `ttlndeposit` DROP INDEX `TTLNDEPOSIT_X`;
ALTER TABLE `ttlndeposit` ADD INDEX `TTLNDEPOSIT_X` (`COOP_ID`, `TXN_DATE`, `TXN_SEQ`, `T_DEPOSIT`, `ACCOUNT_NO`);

ALTER TABLE `updatedeptacc_temp` DROP INDEX `UPDATEDEPTACC_TEMP_X`;
ALTER TABLE `updatedeptacc_temp` ADD INDEX `UPDATEDEPTACC_TEMP_X` (`DEPTACCOUNT_NO`);

ALTER TABLE `vcautodet` DROP INDEX `VCAUTODET_X`;
ALTER TABLE `vcautodet` ADD INDEX `VCAUTODET_X` (`VCAUTO_CODE`, `COOP_ID`, `SEQ_NO`);

ALTER TABLE `vcautomas` DROP INDEX `VCAUTOMAS_X`;
ALTER TABLE `vcautomas` ADD INDEX `VCAUTOMAS_X` (`VCAUTO_CODE`, `COOP_ID`);

ALTER TABLE `vcmapaccidkeep` DROP INDEX `VCMAPACCID_X`;
ALTER TABLE `vcmapaccidkeep` ADD INDEX `VCMAPACCID_X` (`COOP_ID`, `SYSTEM_CODE`, `SLIPITEMTYPE_CODE`, `SHRLONTYPE_CODE`, `SHRLONTYPE_STATUS`);

ALTER TABLE `vctempdesc` DROP INDEX `SYS_C0016315`;
ALTER TABLE `vctempdesc` ADD INDEX `SYS_C0016315` (`COOP_ID`, `SEQ_NO`, `VOUCHER_NO`);

ALTER TABLE `vcucfsystemgen` DROP INDEX `XPKVCUCFSYSTEMGEN`;
ALTER TABLE `vcucfsystemgen` ADD INDEX `XPKVCUCFSYSTEMGEN` (`COOP_ID`, `SYSTEMGEN_CODE`);

ALTER TABLE `vcucfsystemgen` DROP INDEX `VCUCFSYSTEMGEN_X`;
ALTER TABLE `vcucfsystemgen` ADD INDEX `VCUCFSYSTEMGEN_X` (`SYSTEMGEN_CODE`);

ALTER TABLE `vcucfvouchertype` DROP INDEX `PK_VCTYPE`;
ALTER TABLE `vcucfvouchertype` ADD INDEX `PK_VCTYPE` (`COOP_ID`, `VOUCHER_TYPE`);

ALTER TABLE `vcvoucherdet` DROP INDEX `SYS_C0025180`;
ALTER TABLE `vcvoucherdet` ADD INDEX `SYS_C0025180` (`COOP_ID`, `VOUCHER_NO`, `SEQ_NO`);

ALTER TABLE `vcvoucherdetdetail` DROP INDEX `SYS_VCDETAIL`;
ALTER TABLE `vcvoucherdetdetail` ADD INDEX `SYS_VCDETAIL` (`COOP_ID`, `VOUCHER_NO`, `ACCOUNT_ID`, `ORDER_NO`, `ACCOUNT_SIDE`);

ALTER TABLE `webaudit` DROP INDEX `XPKWEBAUDIT`;
ALTER TABLE `webaudit` ADD INDEX `XPKWEBAUDIT` (`COOP_ID`);

ALTER TABLE `webauditdetail` DROP INDEX `SYS_C0016353`;
ALTER TABLE `webauditdetail` ADD INDEX `SYS_C0016353` (`COOP_ID`);

ALTER TABLE `webreportdetail` DROP INDEX `WEBREPORTDETAIL_X`;
ALTER TABLE `webreportdetail` ADD INDEX `WEBREPORTDETAIL_X` (`GROUP_ID`, `REPORT_ID`);

ALTER TABLE `webreportgroup` DROP INDEX `WEBREPORTGROUP_X`;
ALTER TABLE `webreportgroup` ADD INDEX `WEBREPORTGROUP_X` (`GROUP_ID`);

ALTER TABLE `webvariable` DROP INDEX `WEBVARIABLE_X`;
ALTER TABLE `webvariable` ADD INDEX `WEBVARIABLE_X` (`VAR_NAME`);

ALTER TABLE `wfdeptconstant` DROP INDEX `WFDEPTCONSTANT_X`;
ALTER TABLE `wfdeptconstant` ADD INDEX `WFDEPTCONSTANT_X` (`COOP_NO`);

ALTER TABLE `wfdepttype` DROP INDEX `WFDEPTTYPE_X`;
ALTER TABLE `wfdepttype` ADD INDEX `WFDEPTTYPE_X` (`DEPTTYPE_CODE`, `WFTYPE_CODE`);

ALTER TABLE `wfmembertype` DROP INDEX `WFMEMBERTYPE_X`;
ALTER TABLE `wfmembertype` ADD INDEX `WFMEMBERTYPE_X` (`WFTYPE_CODE`);

ALTER TABLE `wfucffeepay_rate` DROP INDEX `WFUCFFEEPAY_RATE_X`;
ALTER TABLE `wfucffeepay_rate` ADD INDEX `WFUCFFEEPAY_RATE_X` (`SEQ_NO`);

ALTER TABLE `wfucfhplncollconstant` DROP INDEX `WFUCFHPLNCOLLCONSTANT_X`;
ALTER TABLE `wfucfhplncollconstant` ADD INDEX `WFUCFHPLNCOLLCONSTANT_X` (`LOANTYPE_CODE`);

ALTER TABLE `wfucfitemtype` DROP INDEX `WFUCFITEMTYPE_X`;
ALTER TABLE `wfucfitemtype` ADD INDEX `WFUCFITEMTYPE_X` (`WFITEMTYPE_CODE`);

ALTER TABLE `wfucfrecppaytype` DROP INDEX `WFUCFRECPPAYTYPE_X`;
ALTER TABLE `wfucfrecppaytype` ADD INDEX `WFUCFRECPPAYTYPE_X` (`RECPPAYTYPE_CODE`);

ALTER TABLE `wfucfsliptype` DROP INDEX `WFUCFSLIPTYPE_X`;
ALTER TABLE `wfucfsliptype` ADD INDEX `WFUCFSLIPTYPE_X` (`SLIPTYPE_CODE`);

ALTER TABLE `xaucfexecutiverank` DROP INDEX `SYS_C0014633`;
ALTER TABLE `xaucfexecutiverank` ADD INDEX `SYS_C0014633` (`EXECRANK_CODE`);

ALTER TABLE `xaucfmisspaycause` DROP INDEX `SYS_C0014635`;
ALTER TABLE `xaucfmisspaycause` ADD INDEX `SYS_C0014635` (`MISSPAYCAUSE_CODE`);

ALTER TABLE `yrbglonmaster` DROP INDEX `SYS_INX_C0001`;
ALTER TABLE `yrbglonmaster` ADD INDEX `SYS_INX_C0001` (`COOP_ID`, `LOANCONTRACT_NO`);

ALTER TABLE `yrconfirmmaster` DROP INDEX `XPKYRCONFIRMMASTER`;
ALTER TABLE `yrconfirmmaster` ADD INDEX `XPKYRCONFIRMMASTER` (`COOP_ID`, `MEMBER_NO`, `BALANCE_DATE`);

ALTER TABLE `yrconfirmstatement` DROP INDEX `YRCONFIRMSTATEMENT_COPY_X`;
ALTER TABLE `yrconfirmstatement` ADD INDEX `YRCONFIRMSTATEMENT_COPY_X` (`AUTO_ID`);

ALTER TABLE `yrreqchgloncondet` DROP INDEX `XPKYRREQCHGLONDET`;
ALTER TABLE `yrreqchgloncondet` ADD INDEX `XPKYRREQCHGLONDET` (`COOP_ID`, `REQCHG_DOCNO`, `SEQ_NO`);





















