6 Replies Latest reply on Jun 4, 2009 2:05 PM by Jim NameToUpdate

    Creating a new Active Link takes 2 minutes

      Hello -


      Our application support staff is reporting the following ARS/Remedy problem:  Creating a new Active Link takes 2 minutes.


      I believe I've captured the long running SQL associated with this function.  I have it as -


      select al.name, max(map.objIndex)+:"SYS_B_0" from actlink al, actlink_mapping map where al.actlinkId = map.actlinkId group by al.name order by al.name


      Any suggestions?  I've run explain on it but there are no recommendations and the tables appear to have the indexes needed.