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.