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

bonsai · ‎02-21-2025

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

bonsai · ‎02-21-2025

What should I check to investigate?

Dr Atul G- LNG · ‎02-21-2025

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.

Hope you were able to search earlier as well and now as well. So nothing much to worry and close the thread.

*************************************************************************************************************
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]

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

JC Moller · ‎02-22-2025

My first initial question seeing the values you are getting: do you have data in the kb_knowledge and are there columns selected in the dictionary for this table to be text indexed?

If the full text indexing for this table runs in 11 seconds then my thought is that you do not have any data to be text indexed?

bonsai · ‎02-22-2025

There is data in the table!

About 100 records.

"are there columns selected in the dictionary for this table to be text indexed?"

→ Where can I find this?