Automic Community

  • 1.  Long running Query

    Posted 02-26-2020 06:04 AM
    Hi All,

    We found that the below query is long running and need to know the purpose of the query.

    INSERT INTO ACV (ACV_AH_Idnr, ACV_VName, ACV_Type, ACV_Encrypted, ACV_Connection, ACV_Key, ACV_Value) SELECT ECV_AH_Idnr, ECV_VName, ECV_Type, ECV_Encrypted, ECV_Connection, ECV_Key, ECV_Value FROM ECV WHERE ECV_AH_Idnr = :A0001

    Can anyone help us.

    Thank you

    Regards,
    Sudheer