Reduce sys_metadata text index build times by migrating sc_cat_item child table to its own text indexIssue When there is a lot of data stored in sys_metadata, this can cause the text index regeneration on this table to take a very long time. For many customers, all of this data isn't needed for text searching so it really doesn't need to be added to the text index. In many cases, only sc_cat_item data is needed for searching so there is no need to index all of sys_metadata. As of New York, we can now migrate sc_cat_item, which is a child table of sys_metadata, to its own text index instead of being indexed as part of sys_metadata. This will allow us to only have to index the sc_cat_item data and we can turn off indexing for the sys_metadata table. ReleaseNew York or laterResolutionMigrate sc_cat_item to it's on text index and turn off indexing on sys_metadata. 1. Confirm that sc_cat_item isn't already migrated a. Go to System Definition/Text Indexes and confirm that the sc_cat_item table is not in this list b. Check if the glide.ts.tables_to_be_migrated property exists with a value of 'sc_cat_item'. If it DOES exist with that value, the table has not been migrated to its own text index. 2. Migrate sc_cat_item a. Go to System Definition/Text Index Configuration and open the sc_cat_item record b. In the 'Related Links' section, click 'Generate Text index' This will create an event called 'text_index.migrate_table' which will migrate the table. When the text_index.migrate_table event is running, these are the steps that are happening: i. The new index for sc_cat_item is created first so you will see this in the 'Text Indexes' list as soon as the index is built. ii. A cache flush is performed due to the glide.ts.tables_to_be_migrated property being updated. iii. The sc_cat_item data is removed from the sys_metadata text index tables. c. Once the text_index.migrate_table event is processed, the migration is completed. d. Go to System Definition/Text Indexes and validate that the sc_cat_item table is now in the list and has a status of 'Ready' 3. Turn off text indexing for sys_metadata a. Go to System Definition/Dictionary b. Open the 'Collection' record for the 'sys_metadata' table nav_to.do?uri=sys_dictionary.do?sys_id=6d8633023720130081f203a973990e3a c. Uncheck the 'Text index' check box and save the change. Related LinksIf you're trying to address slow text indexing with sys_metadata after a clone, this change should be done on the SOURCE instance before cloning. If the text index creation fails due to 'Duplicate entry 'xx' for key 'number'', please see this KB on how to resolve that issue: KB0824449 Unable to Generate a new Text Index