My Oracle Support Banner

EGOIMTIDX - Item Catalog Text Index Build Performance and FAQ (Doc ID 1114934.1)

Last updated on JULY 05, 2023

Applies to:

Oracle Product Hub - Version 12.0.6 and later
Information in this document applies to any platform.
Executable:EGOIMTIDX - Item Catalog Text Index Build
Executable:EGOOPTICTI - Optimize Item Catalog Text Index


Goal

Common questions about the Text Build program used in Product Information Management (PIM) formally called Advanced Product Catalog (APC).

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution
 Q1: What are the programs related to the simple search indexes?
 Q2: What does the Text Build index?
 Q3: When should the Text Build be run?
 Q4: How can one monitor the progress of the text build program?
 Q5: How can one see the logic used in creating the Context Indexes for the Item Simple Search?
 Q6: What is the difference between running the Text Build in Create vs. Rebuild?
 Q7: Does the rebuild program have to be run after importing large number of items?
 Q8: Is it ok to continue and use the system while the text rebuild runs?
 Q9: Any tips on tracing the performance?
 Q10: Number of threads?
 Q11: Can the thread count be controlled?
 Q12: More information on Rebuild of Text Index?
 Q13: How can you improve performance related to "Optimize Item Catalog Text Index"?
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.