Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>>Your index doesn't happen to:
>>>
Be a unique index? Those should never be used, as far as I know.
>>>Include a filter? That might exclude the records you are missing.
>>>
>>>>Just to test I did rebuild the keys on that file, it still only left me with a few of the keys in the index. The rest where still missing.
>>
>>Thnaks Hilmar but I think I haven't explained what happened very clearly.
>>
>>The index file contained many different index tags on many fields and combinations of fields. The problem was that suddenly most of those tags disappeared. But there was no indication of any corruption, it was as though the tags had been deleted.
>
>set a breakpoint when TAGCOUNT("alias") change.
Thanks Fabio but Its not a reproducible error and the file is accessed by many different jobs.
I think it has happened before on this file some time ago
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement
