1. Implementing Global Human Resources
  2. How You Optimize Person Search Keywords

How You Optimize Person Search Keywords

The Oracle Text index in the PER_KEYWORDS table is utilized for person searches in My Client Groups, and the Directory. This index may become fragmented over a period of time and may cause a delay in displaying search results.

Why You Run the Process

You run the Optimize Person Search Keywords Index process to identify the fragmented indexes and help improve the overall search performance. To launch this process, use the Navigator > Tools > Scheduled Processes > Schedule New Process button in the search results table.

Note: You must run the Update Person Search Keywords process first and then the Optimize Person Search Keywords process. You cant schedule both processes simultaneously. If you schedule them at the same time, the second process will wait for the first process to complete before it starts.

When to Run the Process

You must run the Optimize Person Search Keywords Index process daily at times of low activity with the options, Full mode and the appropriate maximum time. The default time is 180 minutes. Although, if the process is run consistently over time it may take about 10 to 30 minutes only. You can decide the frequency of running the process based on the size of your customer base, system usage, database usage, data loaders used, index fragmentation, and schedule of the Update Person Search Keywords process.

Best Practices for Optimizing Person Search Keywords

Here are some best practices for optimizing person search keywords.

Do's

  • Schedule the Optimize Person Search Keywords Index process to run at least once a week during off peak hours with all parameters null, to prevent the keywords index from being fragmented.
  • It’s recommended that you don’t schedule both these processes to run simultaneously:
    • Update Person Search Keywords
    • Optimize Person Search Keywords Index

    Even if you do, the second process waits for the first process to complete before it starts.

  • Let’s say a large volume of person records are updated every day, and the Update Person Search Keywords process is scheduled to run daily. Then you need to schedule the Optimize Person Search Keywords Index process with all parameters as null to run immediately after the Update Person Search Keywords process.

Don'ts

Don’t schedule the Optimize Person Search Keywords Index process to run more frequently than once daily. That’s because the keywords index isn’t expected to be fragmented heavily in such a short period of time.