What is the best practice for Database Index against Short Description?

[andresgo]

We have a requirement to build a database index against a string field like short description in task table.

Wonder if this is something positive or negative for platform performance and what are the best practices around it.

Any comment to understand this better helps 🙂

[Anand Kumar P]

Hi @andresgo ,

ServiceNow uses MySQL to manage data, and when users view records, they’re seeing the results of database queries. Like a book index, MySQL indexes let the database quickly locate rows without scanning everything.

For instance, if you add an index to the “short description” field in the task table, searches on this field can retrieve results faster.In ServiceNow, best practice is to index only fields frequently used in queries. For example, if short description is commonly searched, indexing it can improve performance. But avoid unnecessary indexes, as they can lead to extra overhead without notable benefit.

Refer below link

https://www.servicenow.com/community/developer-blog/improve-performance-database-indexes-and-slow-qu...

Mark it as helpful and solution proposed if it serves your purpose.
Thanks,
Anand