Changes to Indices in Staging Tables

This chapter lists the indices added or modified in the Infor Expense Management application.

Version 10.2.0

These indices are modified in version 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)

These indices were added in version 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 )

This index is added in the version 2022.09

CREATE UNIQUE INDEX alex_xmdbtool__IDX ON

alex_xmdbtool (

table_name

ASC,

xmtype

ASC,

module

ASC,

active_status

ASC )