Tech Tip: How to find the index type when you use Automatic indexes

PRODUCT: 4D | VERSION: 11.4 | PLATFORM: Mac & Win

Published On: May 21, 2009

How do you find out what index structure is used on fields that are set to Automatic indexes? Let's say we have a table with following index structure:

Run "Verify the indexes only" from the "Verify" theme in 4D's MSC, then open the log file. It contains a report on the indexes in your database, including what index structures were applied to the fields.

Commented by on July 30, 2009 at 8:54 AM

I think it's interesting to see what 4D does with Automatic Indexes. Once I get that information I may want to override it and change to an explicit type.

Commented by Josh Fletcher on May 28, 2009 at 6:27 PM

Of course, if you have your indexes set to Automatic when you probably don't care about the type, right? Right? :) Nice tip!