Overview

• 4D v11 SQL at a Glance
• 11 Reasons to Use 4D v11 SQL
• The 4D Ecosystem

4D Products

• Development Products
• Deployment Products
• 4D Web 2.0 Pack v11
• Free Add-Ons

Features

• Release Notes
• Detailed feature list
• Minimum requirements

Getting Started with 4D

• 4D v11 SQL Self-Training
  (PDF + Demo Databases, 141mb)

Resources

• Registration
• Example Databases   3 JUL 08*
• Benchmarks   24 JUN 08*
• Documentation
• Converting to 4D v11 SQL (PDF)
• Training
• Brochures
• Success Stories
• FAQ   2 JUL 08*

* Last Updated

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