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
Your current browser may not allow you to download the asset. We recommend Mozilla Firefox or Google Chrome.
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.