Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: CASANOVA on January 13, 2018, 06:19:38 AM

Title: Query information
Post by: CASANOVA on January 13, 2018, 06:19:38 AM

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.

Title: Re: Query information
Post by: hsujdik on January 13, 2018, 03:57:27 PM

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