How to Reindex a 1C:Enterprise 7.7 and 8.3 Database Properly
Reindexing a 1C:Enterprise database rebuilds its index tables to restore fast lookup performance and relational integrity after an unexpected crash, power outage, or network drop.
Every reindexing operation must run in exclusive (single-user) mode with all users logged out, and you should always take a full backup copy of the database directory before starting.
Reindexing in 1C:Enterprise 7.7 (DBF Database)
In a file-based 1C 7.7 DBF infobase, table data lives inside *.DBF files while indexes are stored separately in *.CDX files. There are two reliable ways to rebuild those indexes:
- Via Configurator (safest method): launch 1C in “Configurator” mode, open
Administration → Testing and Fixing Infobase, check “Reindex infobase tables” (you can uncheck the other boxes if you only need an index rebuild), and click “Execute”. - By deleting
*.CDXfiles in the database folder: have all users exit 1C and delete only the*.cdxfiles inside the database folder (never touch*.dbffiles or the data dictionary1Cv7.DD!). Then start 1C in exclusive mode – the platform automatically regenerates every*.CDXindex file from scratch.
*.CDX: this occasionally happens on large or partially damaged 7.7 databases. Simply open the infobase in Configurator mode instead and run “Testing and Fixing Infobase” with “Reindex” checked – Configurator will recreate the index files cleanly.Deleting *.CDX files before zipping or copying a DBF database folder is also a handy admin trick: the archive shrinks significantly, and 1C rebuilds the indexes in under a minute on the target machine.
Reindexing in 1C:Enterprise 8.2 and 8.3 (File Database 1Cv8.1CD)
In 1C 8.x, the entire file infobase lives inside a single monolithic 1Cv8.1CD file, so there are no standalone index files in the folder. Reindexing works like this:
- Via Configurator: open the infobase in Configurator →
Administration → Testing and Fixing→ check “Reindex infobase tables” (if the1Cv8.1CDfile has bloated, also check “Compress infobase tables”) → click “Execute”. - Using
chdbfl.exe(if Configurator itself will not open): run the built-in physical integrity tool located in your platform’sbinfolder (for example,C:\Program Files\1cv8\8.3.xx.xxxx\bin\chdbfl.exe), point it to1Cv8.1CD, and check “Fix detected errors”.
Is Periodic Reindexing Safe?
Readers asked in the comments whether running a preventive reindex on a DBF database once a week or every morning is harmful. It does not harm your data at all – think of it as tidying up a desk: indexes are rebuilt cleanly, table-lock overhead drops, and reports run noticeably faster. Just make sure the process is never interrupted mid-run and always keep a fresh backup first.
