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 )