What is text index and database index? purpose of those?

[caffry]

Have gone through the below link but still im not sure whats the purpose and how it works

https://community.servicenow.com/community?id=community_question&sys_id=27fca47bdbb98c90f7fca851ca96196f

Can anyone provide me an example for these two

[Omender Singh]

Imagine you need to search for a Keyword in a Book, and you don't have an Index at the end of the Book?

- Only way to find the Keyword is to search the complete Book which takes Minutes even Hours!

If you have an Index in place(which usually stays at the end of the Book), the search will be faster, i.e. in seconds.

The ultimate goal of Indexing -

- Indexes will improve the Query/SQL performance(i.e. GlideRecord Query Response Times) in Scripts.
- Indexes will improve searches on Lists/ Form load times.
- Global search
- Reports/ Homepages/ Dashboards

So, both the indexes have the same purpose one at the application level and the other at the database level.

For more details - Click here

Please mark it correct, if it helped you.

[Aman Kumar S]

Hey,

Text Index

Administrators can enable text indexing on a table to allow users to search for string values from table records.

Text indexing is what allows you to search on text fields for a table. If you want to be able to search, you need to activate text indexing on the table. It really has nothing to do with performance.

Enable Text Index

More ref article to deal with  text indexing

How to track the progress of text indexing (or reindexing) and tell if it has completed

Reduce unnecessary text index events from causing overhead on events processing

Remove an index for a specific field

Database indexing

ServiceNow uses the MySQL database to manage its information, so whenever users are looking at a list of records they’re looking at the results of a database query.

Like all databases, MySQL is designed to handle large volumes of information in the most efficient manner possible. To do this, MySQL has a concept known as indexes. These work very much like the index in the back of a book. Instead of flipping through every page looking for something, a quick trip to the index can let you find all the references for a subject in one spot. In the same way, table indexes increase the speed of database queries.

Below are some articles which really explains with real life demonstration

Understanding Database Indexes in ServiceNow

Create a table index

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0752362

Do let me know, if answers your question 🙂

[Aman Kumar S]

Hey,
Can you confirm, if your issue was resolved?
If yes, please mark correct and close the thread, will be helpful to others 🙂