

  
  ALTER TABLE `dpm_reporting`.`zahlung` DROP INDEX if exists `idxnrfaktura`, ADD INDEX `idxnrfaktura` (`Nrfaktura`) USING BTREE;
  ALTER TABLE `dpm_reporting`.`zahlung` DROP INDEX if exists `idxvaluta`, ADD INDEX `idxvaluta` (nrfaktura,valuta,status) USING BTREE;
  ALTER TABLE `dpm_reporting`.`zahlung` DROP INDEX if exists `stat`, ADD INDEX `stat` (status) USING BTREE;
  ALTER TABLE `dpm_reporting`.`privat` DROP INDEX if exists `pat`, ADD INDEX `pat` (nrprivat) USING BTREE;
  ALTER TABLE `dpm_reporting`.`faktura` DROP INDEX if exists `nrbehandlu`, ADD INDEX `nrbehandlu` (nrbehandlung) USING BTREE;
  ALTER TABLE `dpm_reporting`.`faktura` DROP INDEX if exists `nrfaktura`, ADD INDEX `nrfaktura` (nrfaktura) USING BTREE;
  ALTER TABLE `dpm_reporting`.`leistung` DROP INDEX if exists `cc`, ADD INDEX `cc` (nrbehandler) USING BTREE;
  ALTER TABLE `dpm_reporting`.`leistung` DROP INDEX if exists `ccc`,ADD INDEX `ccc` (`Nrbehandlung`, `SSO-Nummer`);
  ALTER TABLE `dpm_reporting`.`behandlu` DROP INDEX if exists `nrbe`,ADD INDEX `nrbe` (`nrbehandler`);
  ALTER TABLE `dpm_reporting`.`behandlu` DROP INDEX if exists `nrbe1`,ADD INDEX `nrbe1` (`nrbehandlung`);
  ALTER TABLE `dpm_reporting`.`behandlu` DROP INDEX if exists `nrpat`,ADD INDEX `nrpat` (`nrpatient`);
  ALTER TABLE `dpm_reporting`.`behandlu` DROP INDEX if exists `stat`,ADD INDEX `stat` (`status`);
  
  