--i-test 4 for order 502422      
      /*
      CHANGE REPORT for Table SCAN
          - Changing definition of index XAK1SCAN
      ACTION is ALTER or modify Table SCAN
      */

DROP INDEX XAK1SCAN;

CREATE UNIQUE INDEX XAK1SCAN ON SCAN
(
       BUSINESSUNIT_ID                ASC,
       PRIMARYID                      ASC,
       SCANTIMESTAMP                  ASC,
       TREATMENTTYPE_ID               
);

