With [[Commands#Optimize|OPTIMIZE ALL]] and [[Database Module#db:optimize|db:optimize]], new selective indexing options can be assigned to an existing database.
==Index Construction=Performance=
If main memory runs out while creating a value index, the currently generated index structures will be partially written to disk and eventually merged. If the used memory heuristics fails for some reason (i.e., because multiple index operations run at the same time), fixed index split sizes may be chosen via the <code>[[Options#INDEXSPLITSIZE|INDEXSPLITSIZE]]</code> and <code>[[Options#FTINDEXSPLITSIZE|FTINDEXSPLITSIZE]]</code> options.