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?