>>Just a heads-up: at a client I ran into a situation where missing index tags caused extreme slowness.
>>
>>In my case a table (in a DBC) with just under a million rows has a CDX file which was supposed to have 8 tags: one on the primary key plus 7 others. Somehow, the 7 non-PK index tags were no longer present, only the PK tag remained.
>>
>>With the "bad" CDX a test report took 22 minutes to run.
>>
>>When replaced with a "good" one and reindexed, it took 5 seconds to run (250x faster).
>>
>>Over the years I've encountered a number of corrupted CDX scenarios. However they've always been such that the app won't start at all or crashes quickly with an obvious index problem. This is the first time I've run into tags that just silently went missing, without causing any functionality problems with the app (other than slowness).
>
>I've never seen tags just disappear. Perhaps someone restored an old cdx. LOCATE and SQL will operate without the tags. SEEK won't.
Me neither. Impossible that an old .cdx was restored - there has never been one (until now) that has less than 8 tags. The table is open pretty much 24/7 so restoring an old .cdx or running DELETE TAG etc. would be pretty much impossible.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up