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
|Tables
module. Let's create an index for theCaller
field in theBooking Request
table. - In the
System Definition
|Tables
module, open theBooking Request
table by clicking on the info icon next to the record:
- It will bring you up to the details page of the
Booking Request
table's configuration. Navigate to the bottom of the page and click on theNew
button in theDatabase Indexes
related list, as shown in the following screenshot:
- Clicking on the
New
button in theDatabase...