Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>As long as you don't do anything radical in your CDX (like use an expression based on a UDF), yes, it will work, as follows:
True, you even can save the cdx file after you created the table for reconstruction. But it's not about UDFs, you could use that approach even with UDFs in index expressions. But if you would for example index on DATETIME() opposed to indexing a field with default value DATETIME(), reindexing with such a truncated cdx file would change all records index to about the datetime of reindexing.
So, yes, CDX files include data, not only the index expressions but also their evaluations are stored within the CDX, that's why it grows with the DBF.
Bye, Olaf.
Précédent
Suivant
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