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.