4.2. Indexing

You can indicate that a database should be indexed on a field with the INDEX modifier:

        Database sometable  INDEX  category

This will create an ASCII index on every import, and will also create an index on the field at SQL creation time.

If you wish to create SQL indices at table creation time without creating an ASCII index, use the NO_ASCII_INDEX parameter:

        Database sometable  NO_ASCII_INDEX  1

Of course you can create a SQL index manually at any time via your SQL toolset.