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

    Creating a new Active Link takes 2 minutes

    Jim NameToUpdate

      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. 

       

      Jim