Hi,
Text Index
Administrators can enable text indexing on a table to allow users to search for string values from table records.
- Click the table name to open the dictionary entry.
A table in the System Dictionary is a record that has a Table name but no Column name.
3.Select the Text index check box to enable text indexing for text fields on the table.
4.Click Update.
5.Click Generate Text Index.
Database indexing
Indexing is one of the most important database features and must be implemented properly where needed to improve response time. Just like in other database-based applications, creating an index must be dealt with carefully, and only the fields that will be looked up often must be indexed. Indexing will not just improve the response time; it also greatly improves the database performance and can help optimize slow queries:
- In the ServiceNow platform, to create a database index, we can use the
System Definition|Tablesmodule. Let's create an index for theCallerfield in theBooking Requesttable. - In the
System Definition|Tablesmodule, open theBooking Requesttable by clicking on the info icon next to the record:
- In the ServiceNow platform, to create a database index, we can use the
- It will bring you up to the details page of the
Booking Requesttable's configuration. Navigate to the bottom of the page and click on theNewbutton in theDatabase Indexesrelated list, as shown in the following screenshot:
If my response is worthy please mark as correct and helpful
Regards,
Monali Patil
Developer
