Text Indexes
- Enable text indexing on a table to allow users to search for string values from table records
- When implementing text indexes, monitor the instance for any perfomance degradation or incomplete search results
Steps to create a text index
- Table Record
- Table in sys dictionary
- Text Index
Pre-Existing text indexes
- There are a number of baseline tables that have pre-existing text indexes, such as
- knowledge- related tables,
- core-data-related-tables,
- connect-related tables,
- the task table, and the
- user table.
Helps avoid unnecessary issues
- While text indexing can be a resource-intensive task that may take a while to complete, monitoring instance performance should help avoid any unnecessary issues.
Estimate text duration
- To estimate text indexing duration, view the historical statistics by navigating to
- System Definition > Text Indexes.
- If text indexing is in progress, view the status of each index in the State field. To see how long it takes to index a specific table, view the Last indexing duration field for the table entry.
Additional Statistics
- Additional statistics can be found here and be very helpful, including: the number of indexed rows, terms, and queries in the past week.
Remove individual Fields
- Individual fields on an indexed table can be removed from the search, resulting in the system no longer indexing or querying the field for text search results.
- To remove an index for a specific field, navigate to a form containing the field.
- Next, right-click the field label and select Configure Dictionary. Add “no_text_index=true” to the Attributes field, then click Update.
Enable Text Indexing for a table
- To enable text indexing for a table: Navigate to System Definition > Dictionary
- Open the table record by clicking on the table name
- A table in the System Dictionary is a record that has a Table name but no Column name
- Select the Text index checkbox