CREATE INDEX statement

Use the CREATE INDEX statement to speed searches in your database file. The format of the CREATE INDEX statement is:

Copy
CREATE INDEX ON table_name.column_name
CREATE INDEX ON table_name (column_name)

CREATE INDEX is supported for a single column (multi-column indexes are not supported). Indexes are not allowed on columns that correspond to container field types, summary fields, fields that have the global storage option, or unstored calculation fields in a FileMaker Pro database file.

Creating an index for a text column automatically selects the Storage Option of Minimal in Indexing for the corresponding field in the FileMaker Pro database file. Creating an index for a non-text column (or a column formatted as Japanese text) automatically selects the Storage Option of All in Indexing for the corresponding field in the FileMaker Pro database file.

Creating an index for any column automatically selects the Storage Option of Automatically create indexes as needed in Indexing for the corresponding field in the FileMaker Pro database file.

FileMaker software automatically creates indexes as needed. Using CREATE INDEX causes the index to be built immediately rather than on demand.

Example

Copy
CREATE INDEX ON Salespeople.Salesperson_ID