---
sourceDocument: Xanadu ServiceNow AI Platform Administration
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/xanadu/platform-administration

 Release :

    - xanadu

ft:locale :

    - en-US

ft:publication_title :

    - Xanadu ServiceNow AI Platform Administration

ft:clusterId :

    - platadm

bundleId :

    - platadm

workflow :

    - Platform


---

# Resolving slow queries

# Resolving slow queries {#ariaid-title1}

* Release version: Xanadu
* 
* Updated May 6, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

Identifying and resolving slow queries is an important aspect of improving platform performance. The ServiceNow AI Platform generates index suggestions to help resolve slow queries.

Database queries that take an unusually long time to execute might be caused by inefficient query design, high data volume, and lack of proper indexing. The best way to resolve slow queries depends on the combination of factors that
contribute to the issue.
{#resolving-slow-queries__table_c4c_lhw_gfc__entry__2}

| Cause | Possible solution |
|-|-|
| Inefficient query design | Review and modify query structures to enhance performance. Query modifications might include verifying that you're fetching only the necessary data, or implementing pagination at the query level. You can use a slow query log to determine which queries might need to be enhanced. For more information about how to use a slow query log, see [Use a slow query log](https://servicenow-prod.fluidtopics.net/_AduCBrdY1ygrlUXVk1ueg "Administrators can use slow query logs to gain insight into how queries are affecting platform performance. The Slow Queries log aggregates data for similar queries. Use slow query data to evaluate the need for new indexes, changes to existing indexes, or changes to frequent queries."). |
| High data volume | Verify that necessary transaction quotas, application quotas, and operational toggles are set to optimize bandwidth use. For more information, see [Configuring the ServiceNow AI Platform to optimize performance](https://servicenow-prod.fluidtopics.net/G9rDenN6zt6sJ4krB6dL1A "Configure browser settings, transaction and application quotas, and operational toggles options to optimize performance. Optimizing ServiceNow AI Platform performance supports a smooth a responsive user experience."). |
| Lack of proper indexing | Use the Index Suggestion Engine (ISE) to generate index suggestions for selected slow queries. |
[Table 1. Causes and possible solutions for slow queries]

{#resolving-slow-queries__table_c4c_lhw_gfc}

## Overview of using the Index Suggestion Engine {#resolving-slow-queries__section_ch2_2xq_hfc}

The Index Suggestion Engine (ISE) can help generate index suggestions for slow queries. If you modify query design and manage data volume but still notice slow queries, you can use the ISE to generate indexes for slow queries.  
Use the following steps to resolve slow queries with the ISE:

1. [Use the slow query log](https://servicenow-prod.fluidtopics.net/_AduCBrdY1ygrlUXVk1ueg "Administrators can use slow query logs to gain insight into how queries are affecting platform performance. The Slow Queries log aggregates data for similar queries. Use slow query data to evaluate the need for new indexes, changes to existing indexes, or changes to frequent queries.") to identify slow queries that might benefit from improved indexing.
2. [Generate an index suggestion for a slow query](https://servicenow-prod.fluidtopics.net/vRjpy5wYt6JNgpEsrkPpaw "Use the Index Suggestion Engine (ISE) to generate an index suggestion for a slow query. The ISE analyzes slow queries and provides index recommendations to improve execution time when possible.") using the ISE.
3. [Review the index suggestion](https://servicenow-prod.fluidtopics.net/zUJp6Rbnx3HpG9PBZyZOVg "You can review index suggestions and indexes created by the Index Suggestion Engine (ISE). The ISE provides three main views of index suggestions as they move through their life cycle: index suggestions in review, index in progress, and index done.") and decide whether to move forward.
4. [Export a query suggestion from a production instance to a non-production instance](https://servicenow-prod.fluidtopics.net/2azTPmP4jUQDGPyWhJOWZg "You can export an index suggestion from a production instance to a non-production instance for creation, evaluation, and testing before implementing the index on your production instance.") for evaluation before adding the index in your production instance.
5. [Create an index from the suggestion](https://servicenow-prod.fluidtopics.net/9CmZBG~Ss8qaKQErqj_~Ag "Use the Index Suggestion Engine (ISE) to schedule an index suggestion for creation.") or schedule index creation once you're satisfied with the effects of the index suggestion.
6. [Test index performance](https://servicenow-prod.fluidtopics.net/m43tUzg7VO9FIoVv7hiSSw "After the Index Suggestion Engine (ISE) generates an index suggestion for a slow query, you can test the index to see if it improves execution time. If you're evaluating an index suggestion on a non-production instance, you can run this test after creating the index to get immediate results on index performance.") to evaluate query speed improvement.
7. If an index isn't needed anymore, [drop the index or schedule it to be dropped](https://servicenow-prod.fluidtopics.net/nVDDWl3h0BUFEgic2pSNaQ "You can drop an index for a slow query when the index isn’t used by the database or doesn’t improve query performance. You can drop the index immediately or schedule the drop for a later time."). If an index isn't being used or isn't performing well, the ISE might display a suggestion to drop an index.
{#resolving-slow-queries__ol_zjz_51r_hfc}

## Additional info {#resolving-slow-queries__section_lrq_rvr_hfc}

For more information about how the ISE generates index suggestions, see [Index suggestions for slow queries](https://servicenow-prod.fluidtopics.net/ZYWNMZEuPF0KmWyQY52huQ "The Index Suggestion Engine (ISE) can generate an index suggestion for a selected slow query. When you request an index suggestion for a slow query, the ISE analyzes the query and recommends an index that can improve the query execution time.").
* **[Index suggestions for slow queries](https://servicenow-prod.fluidtopics.net/ZYWNMZEuPF0KmWyQY52huQ)**   
  The Index Suggestion Engine (ISE) can generate an index suggestion for a selected slow query. When you request an index suggestion for a slow query, the ISE analyzes the query and recommends an index that can improve the query execution time.
* **[Use a slow query log](https://servicenow-prod.fluidtopics.net/_AduCBrdY1ygrlUXVk1ueg)**   
  Administrators can use slow query logs to gain insight into how queries are affecting platform performance. The Slow Queries log aggregates data for similar queries. Use slow query data to evaluate the need for new indexes, changes to existing indexes, or changes to frequent queries.
* **[Generate an index suggestion for a slow query](https://servicenow-prod.fluidtopics.net/vRjpy5wYt6JNgpEsrkPpaw)**   
  Use the Index Suggestion Engine (ISE) to generate an index suggestion for a slow query. The ISE analyzes slow queries and provides index recommendations to improve execution time when possible.
* **[Review index suggestions for slow queries](https://servicenow-prod.fluidtopics.net/zUJp6Rbnx3HpG9PBZyZOVg)**   
  You can review index suggestions and indexes created by the Index Suggestion Engine (ISE). The ISE provides three main views of index suggestions as they move through their life cycle: index suggestions in review, index in progress, and index done.
* **[Export a slow-query index suggestion to a non-production instance](https://servicenow-prod.fluidtopics.net/2azTPmP4jUQDGPyWhJOWZg)**   
  You can export an index suggestion from a production instance to a non-production instance for creation, evaluation, and testing before implementing the index on your production instance.
* **[Schedule a slow-query index suggestion for creation](https://servicenow-prod.fluidtopics.net/9CmZBG~Ss8qaKQErqj_~Ag)**   
  Use the Index Suggestion Engine (ISE) to schedule an index suggestion for creation.
* **[Test index performance for slow queries](https://servicenow-prod.fluidtopics.net/m43tUzg7VO9FIoVv7hiSSw)**   
  After the Index Suggestion Engine (ISE) generates an index suggestion for a slow query, you can test the index to see if it improves execution time. If you're evaluating an index suggestion on a non-production instance, you can run this test after creating the index to get immediate results on index performance.
* **[Drop a slow query index](https://servicenow-prod.fluidtopics.net/nVDDWl3h0BUFEgic2pSNaQ)**   
  You can drop an index for a slow query when the index isn't used by the database or doesn't improve query performance. You can drop the index immediately or schedule the drop for a later time.