What do the numbers in "Indexed rows[ts_index_name]" for a text index mean?

bonsai
Mega Sage

After re-creating the index, this number remains at 1.
What is this number?

index.JPG

8 REPLIES 8

blaze1
Tera Contributor

The **"Indexed rows[ts_index_name]"** number shows how many records have been processed and included in the text search index.

If the number is **1**, it means only one record has been indexed for full-text search. This could happen for a few reasons:

1. **Only One Record is Eligible**: If there’s only one record with data in the fields that are being indexed, only that record will be counted.

2. **Indexing Not Finished**: After re-creating the index, it might take some time for all records to be indexed. The count could stay at 1 while the system is still processing the other records.

3. **Missing Data**: If the other records don’t have data in the fields that are being indexed, they won’t be counted.

To fix this, you can:
- Check if the records have data in the fields you want to index.
- Wait for the system to finish indexing, especially if it's processing many records.
- Rebuild the index if needed to make sure it indexes all the relevant data.

Blaze Llanos, USMC, MISM
ServiceNow Engineer
Solutions: IT | ServiceNow Expertise Transforming Challenges into Solutions
LinkedIn: https://www.linkedin.com/in/blazellanos/

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @bonsai 

 

Is it still same? Try to reload the page.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

I received the completion email but it's still the same. I've updated it many times.

Hi @bonsai 

 

AGLearnNGrow_0-1740127569935.png

 

 

It tell how  many rows get indexed. Like if you see in my case (example only), it is showng2818. Now please check the main issue, due to which you raised the reindex.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************