create table my_log ( 
    Id INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, 
    A VARCHAR(65), -- A number of filterable columns with relatively few distinct values 
    B VARCHAR(65), -- 
    ProcessingStatus VARCHAR(65), 
    ProcessingTime INTEGER, 
    CREATED TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL 
)

DECLARE  
  insertedId Number(38,0); 
BEGIN 
  INSERT INTO my_log (A) VALUES ('XYZ') returning Id into insertedId; 
  commit; 
  -- Inserted row is updated once after 20-1000ms 
  -- After that no further updates occur 
  UPDATE my_log SET B='ABC', ProcessingStatus='ERROR', ProcessingTime=200 WHERE id=insertedId; 
  commit; 
END; 

CREATE BITMAP INDEX MY_LOG_BIDX1 ON My_Log ("PROCESSINGSTATUS");