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