Log In    |    Knowledge Base    |    4D Home
Tech Tip: How to rebuid specific Indexes in 4D v11 SQL
PRODUCT: 4D Developer | VERSION: 11 | PLATFORM: Mac & Win
Published On: April 23, 2008

4D v11 SQL separates the indexes from the database file. This is one big step to improve the overall performance of the database and make the database file independent from errors associated with the index structure (corrupted index fields, error during index maintenance etc.). Now 4D stores the index key and the index structure in separate files “.4DINDY” and “.4DINDX”. These two files are located on the same level where the structure file is. Despite the performance, this type of index architecture allows easily rebuilding.

To rebuild specific indexes, follow these steps:

Trough the index explorer dialog, next to the “+ -“icon, there is drop down list with two options “Edit” and “Rebuild”. Click on "Rebuild" option.

For a quick way to rebuild all indexes see this Tech Tip: How can I rebuild all indexes in 4D v11 SQL?

Commented by Jody Bevan on July 7, 2011 at 2:17 PM
Where is the Index Explorer found?