CREATE INDEX statement
Use the CREATE INDEX
statement to speed searches in your database file. The format of the CREATE INDEX
statement is:
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.
CREATE INDEX ON Salespeople.Salesperson_ID