>My master table, Contract, has a lot of indexes on dates and the like. These indexes have been disappearing from the table structure. First, is there a practical limit to the number of indexes you can have in the CDX file? If so, what is it? The table has 43 indexes, only one Candidate (the Primary), all the rest are regular simple single field indexes. Last time I had to modify the structure, only about 10 of my indexes where there, the rest were gone.
>
>This is causing some serious performance problems when my indexes go south, so any help would be greatly appreciated.
>
>Grace and peace,
>John
AFAIK, there's not a real limit - I've seen performance hits on big tables where there are that a lot of indexes.
Couple of questions:
[SWAG] Is there a stray CDX file with the same name out there somewhere?
Did the Primary key disappear, or just regular indexes?
When you notice they're gone, are the ones remaining the first 10 (e.g.)?
Is there a DBC - does it have the indexes? I wonder if your DBC got corrupted - try VALIDATEing the DBC and see what you get.
Insanity: Doing the same thing over and over and expecting different results.