ForceField - adding an index to improve performance in finding dup items
Run the following SQL statement to create an index on ORDITEM to speed up dup checking in order line entry:
CREATE INDEX ORDITEMPART_IDX ON ORDITEM(ORDNUM, PARTNUM);
Run the following SQL statement to create an index on ORDITEM to speed up dup checking in order line entry:
CREATE INDEX ORDITEMPART_IDX ON ORDITEM(ORDNUM, PARTNUM);