Log In    |    Knowledge Base    |    4D Home
Tech Tip: How to find the index type when you use Automatic indexes
Published On: May 21, 2009
Your current browser may not allow you to download the asset. We recommend Mozilla Firefox or Google Chrome.
Log In

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!