Product Line Overview 4D Products

• Development Products
• Deployment Products
• 4D Web 2.0 Pack v11

Features List Minimum Requirements Resources

• Registration
• "Wow!" Examples
• "How Do I...?" Examples
• Documentation
• Training
• PDF Brochure
• Success Stories

Index Explorer 

Instantly view all indexes for maximum productivity

This explorer lets you see all your database indexes in one display. This is a useful maintenance tool that will help you increase your database performances and get the best from 4D v11 SQL.

Arrange your indexes

Using the "order by" feature, you can sort indexes by type, field, or name. This helps you spot inconsistencies, or fields with multiple indexes, much more easily.

Intuitive marking

Different index types are assigned different icons to help you spot the difference at a glance.

Configure and optimize your indexes

• You can let 4D choose the best index architecture for your data (automatic type), or select their architecture yourself (cluster, b-tree types) to optimize performance
• A new index option, the keyword index, has been added to help you optimize keyword searches in text fields
• You can optimize for most frequent searches and combined sorts using a composite index (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 feature list

Method Editor >>

International | Company | Contact 4D | Site Map | Privacy Policy | © 4D, Inc. 1995-2008 | Change font size: [A] [A] [A] | | 4D RSS Feeds