CREATE INDEX "WTIC"."IDX_CARTASIGILLOTIPO" 
    ON "WTIC"."LOGTRANS"  (SUBSTR("LOG_DATA",117,8), 
    SUBSTR("LOG_DATA",93,16), SUBSTR("LOG_DATA",33,1), 
    SUBSTR("LOG_DATA",56,1));

CREATE INDEX "WTIC"."IDX_S_CARTASIGILLOTIPO" 
    ON "WTIC"."LOGTRANS_ARCHIVE"  (SUBSTR("LOG_DATA",117,8), 
    SUBSTR("LOG_DATA",93,16), SUBSTR("LOG_DATA",33,1), 
    SUBSTR("LOG_DATA",56,1));


CREATE INDEX "WTIC"."INDEX_DATA_EMISSIONE" 
    ON "WTIC"."LOGTRANS"  (SUBSTR("LOG_DATA",65,8));


CREATE INDEX "WTIC"."INDEX_DATA_EVENTO" 
    ON "WTIC"."LOGTRANS"  (SUBSTR("LOG_DATA",178,8)) ;


CREATE INDEX "WTIC"."INDEX_S_DATA_EMISSIONE" 
    ON "WTIC"."LOGTRANS_ARCHIVE"  (SUBSTR("LOG_DATA",65,8));

CREATE INDEX "WTIC"."INDEX_S_DATA_EVENTO" 
    ON "WTIC"."LOGTRANS_ARCHIVE"  (SUBSTR("LOG_DATA",178,8)) ;

CREATE INDEX "WTIC"."INDEX_S_TITOLO_ABBONAMENTO" 
    ON "WTIC"."LOGTRANS_ARCHIVE"  (SUBSTR("LOG_DATA",33,1));

CREATE INDEX "WTIC"."INDEX_TITOLO_ABBONAMENTO" 
    ON "WTIC"."LOGTRANS"  (SUBSTR("LOG_DATA",33,1));

