Altbestand enhance_iwm_articles_new_add_index

Definition prüfen

Raw YAML Metadaten

engine Typ

valid Parse-Status

Managed Status

draft

importEngine Kurzinfo

Raw YAML

Dateiinhalt

#Connections
Source_Config: importEngine #config - credetials of source connection service
Target_Config: importEngine #config - credentials of target connection service
#Engine Mode


Source_Datapool: iwm_articles_new
Target_Datapool: iwm_articles_new

Plain_Sql: ALTER TABLE iwm_articles_new ADD INDEX idx_tab_key_aa01 (tab_key_AA01);
           ALTER TABLE iwm_articles_new ADD INDEX idx_tab_key_aa02 (tab_key_AA02);
           ALTER TABLE iwm_articles_new ADD INDEX idx_tab_key_aa03 (tab_key_AA03);
           ALTER TABLE iwm_articles_new ADD INDEX idx_aiaa01 (AIAA01);
           ALTER TABLE iwm_articles_new ADD INDEX idx_aiaa02 (AIAA02);
           ALTER TABLE iwm_articles_new ADD INDEX idx_aiaa03 (AIAA03);
           ALTER TABLE iwm_articles_new ADD INDEX idx_arte_auspr (ARTE, AUSPRAEGUNGSNUMMER);

Metadata

Erkannte Konfiguration

Diese Sicht basiert auf der aktuell lesbaren Legacy-Datei und hilft beim Vergleichen vor dem Import.

Source_Config	importEngine
Target_Config	importEngine
Source_Datapool	iwm_articles_new
Target_Datapool	iwm_articles_new
Plain_Sql	ALTER TABLE iwm_articles_new ADD INDEX idx_tab_key_aa01 (tab_key_AA01); ALTER TABLE iwm_articles_new ADD INDEX idx_tab_key_aa02 (tab_key_AA02); ALTER TABLE iwm_articles_new ADD INDEX idx_tab_key_aa03 (tab_key_AA03); ALTER TABLE iwm_articles_new ADD INDEX idx_aiaa01 (AIAA01); ALTER TABLE iwm_articles_new ADD INDEX idx_aiaa02 (AIAA02); ALTER TABLE iwm_articles_new ADD INDEX idx_aiaa03 (AIAA03); ALTER TABLE iwm_articles_new ADD INDEX idx_arte_auspr (ARTE, AUSPRAEGUNGSNUMMER);