Text index - what is the impact?

rafas_10
Tera Guru

Hi everyone,

 

I have a question:

I have a text index for the 'sn_hr_core_case' table. Out of the box, this doesn't exist, it's done on the 'task' table.

 

If I delete my text index on 'sn_hr_core_case' table and re-index it back on the 'task' table, what would be the impact?

 

Thank you!

1 ACCEPTED SOLUTION

Community Alums
Not applicable

Hi @rafas_10 ,

You can remove the index for a table if you no longer want the search engine to return results for that table. This procedure also removes the index for all tables that extend the specified table. which means in your case "Task Table" which is getting extended by HR case Table.

 

Also, You can remove the text index for a child table if you no longer want the search engine to return results for that child table.

The Text index option for a table is inherited by all of that table's child tables. Clearing this option for an individual child table has no effect.

For example, Text index is selected for the Task table in the base system. This setting enables text indexing for the Task table. All tables that extend Task, such as Catalog Task, Incident, and Request, inherit this option. Clearing the Text index option in the Incident child table doesn't disable text indexing for Incident records.

To disable text indexing for a specific child table, set that table's No text index attribute. This attribute overrides the table's inherited Text index option without affecting indexing behavior for other tables in its hierarchy.

 

View solution in original post

2 REPLIES 2

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @rafas_10 

 

There will no impact if you re-index.

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

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

Community Alums
Not applicable

Hi @rafas_10 ,

You can remove the index for a table if you no longer want the search engine to return results for that table. This procedure also removes the index for all tables that extend the specified table. which means in your case "Task Table" which is getting extended by HR case Table.

 

Also, You can remove the text index for a child table if you no longer want the search engine to return results for that child table.

The Text index option for a table is inherited by all of that table's child tables. Clearing this option for an individual child table has no effect.

For example, Text index is selected for the Task table in the base system. This setting enables text indexing for the Task table. All tables that extend Task, such as Catalog Task, Incident, and Request, inherit this option. Clearing the Text index option in the Incident child table doesn't disable text indexing for Incident records.

To disable text indexing for a specific child table, set that table's No text index attribute. This attribute overrides the table's inherited Text index option without affecting indexing behavior for other tables in its hierarchy.