Performance considerations for indexing

Issues must be considered when attempting to enhance performance during indexing.

To enhance performance during indexing, consider the following issues:
  • Use a VARCHAR data type to store the text documents instead of LONG VARCHAR or CLOB.
  • Use separate physical disks to store the text index and the database files.
  • Use small primary key columns, such as TIMESTAMP and INTEGER instead of VARCHAR types.
  • Ensure that your system has enough real memory available for all this data. If there is insufficient memory, the operating system uses paging space instead. This decreases indexing and search performance.
  • The update commitcount parameter, used during the automatic or manual updating of the index, slows down the indexing performance during incremental indexing. Note that the parameter is not used during the initial update process.
  • Performance may decrease during index update if many error and warning messages are written to the event log table.