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

[Anthony Holloway]

Oh wow, that is interesting for sure.

I wish I could spin up a fresh HA 11.6(2) for you.

Good luck and do post back here and to the forums if you end up solving
it.  I'd like to know myself.

On Mon, May 11, 2020 at 12:37 PM cormac o donnell <
cormacodonnell at hotmail.com> wrote:

> 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 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> 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
> 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/4bae9c26/attachment.htm>