DROP INDEX statement

Use the DROP INDEX statement to remove an index from a database file. The format of the DROP INDEX statement is:

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

Remove an index when your database file is too large, or you don’t often use a field in queries.

If your queries are experiencing poor performance, and you’re working with an extremely large FileMaker Pro database file with many indexed text fields, consider dropping the indexes from some fields. Also consider dropping the indexes from fields that you rarely use in SELECT statements.

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

The PREVENT INDEX CREATION attribute is not supported.

Example

Copy
DROP INDEX ON Salespeople.Salesperson_ID