Changes to indices in Transaction Tables

These indices are modified in Infor Expense Management 10.2.0:

  • CREATE INDEX IDX_OVERAGE_LINES_OVERAGE_ID ON aler_overage_lines(overage_id)
  • CREATE INDEX IDX_WI_HISTORY_TIME_MODIFIED ON alwf_wi_history(time_modified)
Added in 10.2.4
  • CREATE UNIQUE INDEX uniqueBkgProcessId__IDX ON alco_background_process_status(bkg_process_id);
Added in 10.2.6
  • CREATE UNIQUE INDEX idx_import_li_external_id ON alco_import_line_item (import_external_id);
Added in 10.2.13
  • CREATE INDEX idx_user_login_active_status ON alco_user ( user_login ASC, active_status ASC )
Added in 10.2.16
  • CREATE INDEX idx_wi_hist_rev_list_id ON alwf_wi_history_reviewers ( wi_history_id ASC )
  • CREATE INDEX idx_wi_hist_rev_user_id ON alwf_wi_history_reviewers ( user_id ASC )
  • CREATE INDEX idx_wi_hist_rev_grp_id ON alwf_wi_history_reviewers ( group_id ASC )

Added in 10.2.17

CREATE INDEX IDX_WI_HISTORY_TRANSITION_ID ON alwf_wi_history (transition_id, work_item_id, author_user_id, time_modified, proxy);

Added in 10.2.18

CREATE UNIQUE INDEX XAK1alco_user ON alco_user (identity2) where identity2 is not null;

Added in 10.2.19

CREATE INDEX alco_etl_table_modified__IDX ON alco_etl_table_modified ( table_name ASC ).

Added in 10.2.20

CREATE INDEX idx_rate_source_id ON alco_fx_rate ( fx_rate_source_id ASC )

Modified in 10.2.20

CREATE UNIQUE INDEX XAK1alc_fx_rate ON

alco_fx_rate (

fx_rate_source_id

ASC,

valid_date

ASC,

currency_fmt_defn_id

ASC )