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
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