What do the numbers in "Indexed rows[ts_index_name]" for a text index mean?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-21-2025 12:30 AM
After re-creating the index, this number remains at 1.
What is this number?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-21-2025 12:34 AM
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.
ServiceNow Engineer
Solutions: IT | ServiceNow Expertise Transforming Challenges into Solutions
LinkedIn: https://www.linkedin.com/in/blazellanos/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-21-2025 12:37 AM
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]
****************************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-21-2025 12:42 AM
I received the completion email but it's still the same. I've updated it many times.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-21-2025 12:47 AM
Hi @bonsai
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]
****************************************************************************************************************