Rebuilding an index for specific fields


The AR System server periodically optimizes Full Text Search (FTS) indexes after AR System requests are added, changed, or deleted.

Re-indexing considerations

In most cases, you need not rebuild FTS indexes. However, the following exceptions apply to on-premises deployments:

  • If you change your Ignore Words List, Root Word List, or Thesaurus, you must rebuild the FTS indexes. For more information, see How-FTS-indexing-works.
  • If you change your Ignore Words List, Root Word List, or Thesaurus and do not re-index, then only the entries inserted, deleted, or modified after that time are affected. 
  • If you change the Case Sensitivity setting, you must rebuild the FTS indexes, and the re-indexing is started automatically when the change is saved.
  • Updates to entries for join, vendor, and view form types are not always generated in the same manner as regular forms. For more information, see Scheduling-FTS-indexing-scans-for-join-vendor-and-view-forms.

To rebuild the index for a specific field:

  1. In the Field Properties window, on the Database Properties tab, clear the field for indexing, and click Save.
  2. Reselect the field for indexing and click Save.

Time required to rebuild a set of indexes

Best practice

We recommend that you perform bulk indexing during off-peak hours, such as during a maintenance window.

Do not rebuild indexes during normal production hours. The time it takes to rebuild the indexes depends on the following factors:

  • The number of fields selected for FTS
  • The amount of data in each field indexed for FTS in each AR System request
  • The system load

For more information about locating your FTS indexes, see Estimating-the-size-of-the-FTS-index.

Re-indexing due to field and form property changes

Changes to the following field values result in the re-indexing of the FTS indexes:

  • For multiple-form FTS, when you change the name in the Title field, the new Title field is re-indexed for all existing entries. This updates the Title field values in the FTS index.
  • If you remove the field name in the Title field, the field is re-indexed to remove the Title field values from the index.
    For more information, see Configuring-forms-for-multi-form-FTS.
  • When you add, remove, or change the Full Text MFS Category Name field property for a field, the field is re-indexed.
    For more information, see Defining-a-field-for-FTS.
  • If you change the Literal FTS Index field property for a field, the field is re-indexed.
  • If you change the Strips Tags For FTS field property for a field, the field is re-indexed.

(On-premises deployments) Re-indexing considerations after modifying the Ignore Words List, Root Word List, or Thesaurus

Consider the following points when you modify the Ignore Words ListRoot Word List, or Thesaurus:

  • If you do not re-index after modifying the Ignore Words ListRoot Word List, or Thesaurus, the changes take effect only for the entries added or modified after the update. 
    For example, if you add network to the Ignore Words List, and do not re-index, the FTS index ignores the word network only for the newly added or modified  AR System requests. However, the FTS index with the word network would still exist for all requests created before the Ignore Words List was modified. 
  • When you re-index all the fields in all your forms that are currently flagged as indexed for FTS, you create a new FTS index that ignores the word network in all requests. 
  • If you modify Ignore Words ListRoot Word List, or Thesaurus, you must restart the server for the changes to take effect.
  • To change the Ignore Words ListRoot Word List, or Thesaurus, see Configuring-FTS-for-localization or Configuring-FTS-by-using-the-Server-Information-form

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*