Index Explorer

Instantly view all indexes for maximum productivity

This explorer lets you view your database indexes in their entirety in an array. Management and administration of indexes becomes greatly simplified.

Arrange your indexes

Using the available order by features, you can gather indexes by type, field, or name. By doing this, you can easily view all indexes of a specific types and avoid any incoherencies.

By performing a sort by field, you can easily identify any fiends with multiple indexes.

Intuitive marking

The badges associated with the index allow you to quickly locate a specific type of index.

Configure and optimize your indexes

Let 4D choose the architecture of your indexes depending on the data (automatic type) or select their architecture yourself (cluster, b-tree types) for customized performance.
Take advantage of a new type of index (keyword index) to speed up searches in dramatic fashion for keywords in text fields.
Optimize the most frequently searches and combined order by using composite indexes (multiple fields index).

The add and delete functions in this explorer make it a true administration tool that allows you to optimize the performance of your database and take full advantage of 4D v11 SQL’s capabilities.

<< Structure Editor

Back to the features list

Method Editor >>