Indexpath

CREATE INDEX `idx_concessionaire_meterreader_id` ON `concessionaire` (meterreader_id) COMMENT '' ALGORITHM DEFAULT LOCK DEFAULT;
CREATE INDEX `idx_billreceivable_billNo` ON `billreceivable` (billNo) COMMENT '' ALGORITHM DEFAULT LOCK DEFAULT;
CREATE INDEX `idx_billreceivable_concessionaireNo` ON `billreceivable` (concessionaireNo) COMMENT '' ALGORITHM DEFAULT LOCK DEFAULT;
CREATE INDEX `idx_billreceivable_billId` ON `billreceivable` (billId) COMMENT '' ALGORITHM DEFAULT LOCK DEFAULT;
CREATE INDEX `idx_billreceivable_billType` ON `billreceivable` (billType) COMMENT '' ALGORITHM DEFAULT LOCK DEFAULT;
CREATE INDEX `idx_billreceivablestatement_accountsReceivableId` ON `billreceivablestatement` (accountsReceivableId) COMMENT '' ALGORITHM DEFAULT LOCK DEFAULT;
CREATE INDEX `idx_bill_meterId` ON `bill` (meterId) COMMENT '' ALGORITHM DEFAULT LOCK DEFAULT;
CREATE INDEX `idx_bill_concessionaireId` ON `bill` (concessionaireId) COMMENT '' ALGORITHM DEFAULT LOCK DEFAULT;
CREATE INDEX `idx_bill_billType` ON `bill` (billType) COMMENT '' ALGORITHM DEFAULT LOCK DEFAULT;