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);

 

 

Article Details

Article ID:
157
Date added:
2013-01-03 21:22:37
Views:
308
Rating (Votes):
(495)