Changes to Indices in Staging Tables

These indices are modified in Infor Expense Management 10.2.0:

• CREATE INDEX idx_export_er_hdr_id ON aler_export_external_data(export_er_hdr_id)
• CREATE INDEX idx_update_status ON aler_export_external_data(update_status)

Added in 10.2.10

• CREATE INDEX idx_erdoc_user_ekey ON alex_import_er_document ( user_ekey ASC )
• CREATE INDEX idx_erdoc_import_status ON alex_import_er_document ( import_status ASC )
• CREATE INDEX idx_erdoc_submit_status ON alex_import_er_document ( submit_status ASC )
• CREATE INDEX idx_erli_user_ekey ON alex_import_er_line_item ( user_ekey ASC )
• CREATE INDEX idx_erli_import_status ON alex_import_er_line_item ( import_status ASC )
• CREATE INDEX idx_prdoc_user_ekey ON alex_import_pr_document ( user_ekey ASC )
• CREATE INDEX idx_prdoc_import_status ON alex_import_pr_document ( import_status ASC )
• CREATE INDEX idx_prdoc_submit_status ON alex_import_pr_document ( submit_status ASC )
• CREATE INDEX idx_prli_user_ekey ON alex_import_pr_line_item ( user_ekey ASC )
• CREATE INDEX idx_prli_import_status ON alex_import_pr_line_item ( import_status ASC )
• CREATE INDEX idx_tpdoc_user_ekey ON alex_import_tp_document ( user_ekey ASC )
• CREATE INDEX idx_tpdoc_import_status ON alex_import_tp_document ( import_status ASC )
• CREATE INDEX idx_tpdoc_submit_status ON alex_import_tp_document ( submit_status ASC )
• CREATE INDEX idx_tpli_user_ekey ON alex_import_tp_line_item ( user_ekey ASC )
• CREATE INDEX idx_tpli_import_status ON alex_import_tp_line_item ( import_status ASC )