TECH / Software & Services 3 min read

How to Reindex a 1C:Enterprise 7.7 and 8.3 Database Properly

Antonio NEMCD Author
Published Sep 16, 2008 · 3 min

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.

Reindexing a 1C:Enterprise database

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:

  1. 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”.
  2. By deleting *.CDX files in the database folder: have all users exit 1C and delete only the *.cdx files inside the database folder (never touch *.dbf files or the data dictionary 1Cv7.DD!). Then start 1C in exclusive mode – the platform automatically regenerates every *.CDX index file from scratch.
If 1C refuses to open in Enterprise mode after deleting *.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 the 1Cv8.1CD file 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’s bin folder (for example, C:\Program Files\1cv8\8.3.xx.xxxx\bin\chdbfl.exe), point it to 1Cv8.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.

Related posts:

Leave a Comment