Database transactions performed during a pdm_k_reindex

Document ID : KB000025361
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:
What are the database transactions that are performed during a pdm_k_reindex?

 

 

 

Answer: 

 

The following database transactions are performed during a pdm_k_reindex.

 

This command initializes the utility for re-indexing knowledge documents and updating search related settings.

  1. Turns on flag in column "reindex_on" in the table: "USP_PROPERTIES".

  2. Truncates current search table ("EBR_FULLTEXT" or "EBR_FULLTEXT_ADM" tables).

  3. Populates current search table with keyword data
    ("EBR_FULLTEXT" or "EBR_FULLTEXT_ADM" tables).

  4. Copies changed/added "noise-words", "special terms", "synonyms", and "parse settings" in the "EBR_PROPERTIES" table.

  5. Switch tables ("EBR_FULLTEXT" or "EBR_FULLTEXT_ADM" tables).

  6. Creates indexes in the current table ("EBR_FULLTEXT" or "EBR_FULLTEXT_ADM" tables).

  7. Turns off the flag in the "reindex_on" column in the table "USP_PROPERTIES".