Maintaining TEXT Indexes

If your users start to witness slow document searches after some time while using PPM Database DMS, the possible root cause might be TEXT index fragmentation. There are two solutions when this occurs:

  • Drop and re-create the index(es). This can be time consuming if you have lots of documents, and during the index rebuilding time, not all documents might be searchable.

  • Optimize the index(es). There are multiple levels of index optimization depending on how complete you want the optimization to be. For example, to perform a fast optimization of the tip document contents index, you should run:

    exec ctx_ddl.optimize_index('DMS_TIP_DOC_IDX','FAST');

Extensive documentation on Oracle TEXT index optimization can be found on Oracle web site, such as: