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:

1. In the ServiceNow platform, to create a database index, we can use the System Definition | Tables module. Let's create an index for the Caller field in the Booking Request table.
2. In the System Definition | Tables module, open the Booking Request table by clicking on the info icon next to the record:

3. 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 the New button in the Database Indexes related list, as shown in the following screenshot:

4. Clicking on the New button in the Database...