Disabling and enabling a forest of trees index

You can use the INDEXES DISABLED option of the SET Database Object Mode statement of SQL to disable a forest of trees index, if you want the server to stop updating the index and to stop using it during queries. After you are ready to put the index into production, you can use the INDEXES ENABLED option to re-enable it.

To disable a forest of trees index:

Run the SET INDEXES DISABLED statement of SQL.

For example, for an index named fotidx, specify:

SET INDEXES fotidx DISABLED;

You can re-enable a disabled forest of trees index, for example, by specifying:

SET INDEXES fotidx ENABLED;