<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body>
<div dir="auto" style="direction: ltr; margin: 0; padding: 0; font-family: sans-serif; font-size: 11pt; color: black; ">
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.
<span id="ms-outlook-android-cursor"></span>Cisco have said the table should only have one index ..which baffles me .
<br>
<br>
</div>
<div dir="auto" style="direction: ltr; margin: 0; padding: 0; font-family: sans-serif; font-size: 11pt; color: black; ">
<span id="OutlookSignature">
<div dir="auto" style="direction: ltr; margin: 0; padding: 0; font-family: sans-serif; font-size: 11pt; color: black; ">
Sent from <a href="https://aka.ms/blhgte">Outlook Mobile</a></div>
</span><br>
</div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Anthony Holloway <avholloway+cisco-voip@gmail.com><br>
<b>Sent:</b> Monday, May 11, 2020 6:23:14 PM<br>
<b>To:</b> cormac o donnell <cormacodonnell@hotmail.com><br>
<b>Cc:</b> cisco-voip@puck.nether.net <cisco-voip@puck.nether.net><br>
<b>Subject:</b> Re: [cisco-voip] uccx contactcalldetail table - number of indexes</font>
<div> </div>
</div>
<div>
<div dir="ltr">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.
<div><br>
</div>
<div>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?</div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>Even the <a href="http://devnetsandbox.cisco.com">devnetsandbox.cisco.com</a> might show unexpected results since those are never fresh installs either. Otherwise, I'd recommend that.</div>
</div>
<br>
<div class="x_gmail_quote">
<div dir="ltr" class="x_gmail_attr">On Sun, May 10, 2020 at 6:58 PM cormac o donnell <<a href="mailto:cormacodonnell@hotmail.com">cormacodonnell@hotmail.com</a>> wrote:<br>
</div>
<blockquote class="x_gmail_quote" style="margin:0px 0px 0px 0.8ex; border-left:1px solid rgb(204,204,204); padding-left:1ex">
<div dir="ltr">
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
HI </div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
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 ? </div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Regards</div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Cormac</div>
</div>
_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" rel="noreferrer" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br>
</blockquote>
</div>
</div>
</body>
</html>