[cisco-voip] uccx contactcalldetail table - number of indexes

[cormac o donnell]

We had a query which was running for 8 years with no issues. After a "glitch" one weekend on the uccx the query went from taking 40ms to 500000ms . When I ran on sub it still only took 40 ms . I looked at the difference between the tables used in the query and pub had one index on contactcalldetail while sub had two indexes . It seems that pub has lost an index. Cisco have said the table should only have one index ..which baffles me .

Sent from Outlook Mobile<https://aka.ms/blhgte>

________________________________
From: Anthony Holloway <avholloway+cisco-voip at gmail.com>
Sent: Monday, May 11, 2020 6:23:14 PM
To: cormac o donnell <cormacodonnell at hotmail.com>
Cc: cisco-voip at puck.nether.net <cisco-voip at puck.nether.net>
Subject: Re: [cisco-voip] uccx contactcalldetail table - number of indexes

Hey there! I saw your post on the forums too, and I looked in the database schema to see if that information was in there, and I didn't find it.

Out of curiosity, what do you need this information for?  Simply to know if there is an issue between the difference on the pub and sub?

I don't have the resources to spin up a new 11.6(2) HA fresh for you to check, but maybe someone else can or knows something.

Even the devnetsandbox.cisco.com<http://devnetsandbox.cisco.com> might show unexpected results since those are never fresh installs either.  Otherwise, I'd recommend that.

On Sun, May 10, 2020 at 6:58 PM cormac o donnell <cormacodonnell at hotmail.com<mailto:cormacodonnell at hotmail.com>> wrote:
HI

I have an issue with UCCX install. The pub and sub arenot in sync it seems. in particular the ContactCallDetail table on SUB has two indexes but the same table on PUB has only one. Can anyone confirm the number of indexes the ContactCallDetail table should have by default - on a fresh install ?

Regards

Cormac
_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net<mailto:cisco-voip at puck.nether.net>
https://puck.nether.net/mailman/listinfo/cisco-voip
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20200511/1501e2fe/attachment.htm>