Log In    |    Knowledge Base    |    4D Home
Tech Tip: How can I rebuild all indexes in 4D v11 SQL?
PRODUCT: 4D Developer | VERSION: 11 | PLATFORM: Mac & Win
Published On: September 26, 2007

Indexes in 4D v11 SQL are stored in external files. These files are named as follows:

  • DatabaseName.4DIndy: contains the index of the structure.
  • DatabaseName.4DIndx (optional): contains the index of the data.

To force the indexes to be rebuilt, simply delete these files.