Defining field indexing options
In FileMaker Pro, you can create indexes, which are lists of the words or values in a field. FileMaker Pro uses indexes for searching and for joining related tables. Indexes increase the speed of searches but also increase file size.
FileMaker Pro uses different indexes for different tasks:
 •
Note  Some behavior is dependent upon the data source or drivers when using Japanese collation that does not distinguish Katakana or Hiragana, either in full- or half-width. This is also the case with Roman characters with accents.
 •
To set indexing options for a field:
1.
With the database open, choose File menu > Manage > Database.
Note  To set options for fields in Table View, right-click the column heading for the field, choose Field > Field Options from the shortcut menu, then skip to step 6.
2.
3.
4.
5.
Click Options (or double-click the field name).
6.
If you selected a calculation field, you see the Specify Calculation dialog box. Click Storage Options.
7.
 
A language from the Default language list
8.
For calculation fields, select Do not store calculation results if you want FileMaker Pro to calculate the result only when needed, then click OK.
9.
Click OK to close the Options for Field dialog box, or click another tab to set additional field options.
Notes
 •
 •
 •
 •
For normal use, use None or Minimal and enable the option to Automatically create indexes as needed.
 •
Selecting All for text fields can significantly increase file size, as every word in the text field is indexed. Certain operations, such as importing records, may also take more time, as each word in the field is added to the field’s index as the import occurs.
 •
Automatically create indexes as needed indexes the field the first time a user performs a find request (searches) on the field. The first search is slow because the index is being created. However, subsequent searches on that field are faster because they use the index. (This option also creates an index when the field is used in a relationship.)
 •
 •
To reduce file size and prevent users from creating indexes, use None (or Minimal) and disable Automatically create indexes as needed.
 •
The combination of selecting None and disabling Automatically create indexes as needed prevents the field from being used to create relationships.
 •
 •
Related topics 
Using a field index