<html><head><meta http-equiv="Content-Type" content="text/html charset=iso-8859-1"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><br><div><div>On Nov 15, 2013, at 4:19 AM, Chris Jones <<a href="mailto:cjones@daz3d.com">cjones@daz3d.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div style="font-family: Helvetica; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;"><div dir="ltr">So I re-indexed the problem table again and ran diagnosis on it, I am an error box that says:<div><br></div><div>"Kernel error: 0x83504. Unique violation of index " S".</div><div><br></div><div>Running diagnosis again I get:</div><div><br></div><div><div>Field: fldKeyword. Index record count (246125) differ from field one (323470).</div><div>Field: fldKeyword. Index have 77345 missing records.</div><div><br></div><div><br></div><div>Problems found! ( Table: tblKeyword )</div></div><div><br></div></div></div></blockquote></div><div><br></div>Could you send that db for testing?<div>Is there the same results for that queries without any indexes on fldKeyword?</div><div><br><div>
<span class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px;"><div>-- <br>Best regards,<br>Ivan Smahin<br>Senior Software Engineer<br>Paradigma Software, Inc<br>Valentina - The Ultra-Fast Database<br><a href="http://www.valentina-db.com/">http://www.valentina-db.com</a></div></span>
</div>
<br></div></body></html>