Query information

[CASANOVA]

Hi,

Can any one help me what is the below query is.

select *
from
(select Interaction.StartDate, Interaction.MediaTypeId, Interaction.SubtypeId, Interaction.TypeId, Interaction.Subject, Interaction.Id, Interaction.TenantId
from Interaction
where (Interaction.ContactId = :1 ) and (Interaction.StartDate >= :2 ) order by Interaction.StartDate desc )
WHERE ROWNUM <= 2000

This query is firing on database and is not getting completed quickly. Due to this UCS transactions are getting delayed ans Slowness in Eservice is observed.

[hsujdik]

Probably its WDE asking UCS for all the interactions of a specific customer. Try to create a composite Index on the database for the table Interaction on fields CustomerId and Start Date (Desc). Also, be sure to perform regular database maintenance, such as index rebuild and table defragmentation