|
The text index is expensive in terms of creation and maintenance, especially if a database is large, or dynamic in nature. Index maintenance is necessary after you perform DML (INSERT, UPDATE, or DELETE) on the base table. The Text Indexes can be maintained using the option Sync/optimize Text Index in CES. This feature is used to schedule or remove or change the job to Synchronize or Optimize Text Index. The topics covered in this section are: |
|
The Sync/Optimize Text Index allows scheduling job to synchronize the text index with the base table at regular intervals or once. |
|
|
||
![]() |
|
|
Schedule, Change, or Remove job to Sync/Optimize Text Index These options
requires the init.ora parameter JOB_QUEUE_PROCESSES to be set to non-zero
value greater than one. |
||||||||||
|
This task explains how to schedule, change or remove job to Sync/Optimize Text Index. | ||||||||||
![]() |
|