{{tag>category:"OpenInsight 32-Bit" author:"Martin Drenovac" author:"Dave Harmacek"}}

[[https://www.revelation.com/the-works|Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community]]


==== PROGRAMATICALLY VALIDATE INDEX (OpenInsight 32-Bit) ====
=== At 12 APR 2010 01:49:33AM Martin Drenovac wrote: ===
 
 
<QUOTE>
Curious to know how I can programatically verify table indices are in place (exist) and correct.



Have a couple of unexplained occurrences where the same select produces different results, and the select is using indices to get to the data.



Thank you
</QUOTE>
----

=== At 12 APR 2010 08:27AM Dave Harmacek wrote:  ===

<QUOTE>In my experience this has happened because a revelation delimiter is in the key of some row or rows of the table that is indexed.  This causes a misalignment of the btree structure that depends upon where in the structure the bad key exists.  So, some searches are fine, others skewed.



So, I make a program that scans all keys looking for those that contain revelation delimiters and make a SYSLISTS (or LISTS) entry, and save the bad rows with valid keys.



Dave

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=WORKS_READ&SUMMARY=1&KEY=42ADA69026D7812A85257703002000AE|View this thread on the Works forum...]]