Synchronizing a Text Index

Previous

Next

You can synchronize the selected Text index. Depending on whether this index has partitions, upon selecting Synchronize and clicking Go for the index, you will be taken to the Synchronize Text Index page for partitioned indexes or non-partitioned indexes. Additionally, you can click Show SQL to view the comparable SQL statements for this operation.

To synchronize a partitioned Text index:

1. From the Text Indexes page, in the list of indexes, select the index that you want to synchronize.

2. From the list of available actions, select Synchronize.

3. Click Go.

   The Synchronize Text Index page appears. This page displays options depending on whether the index is partitioned or not. For partitioned indexes, a list of the partitions on this Text index is given where you can specify memory allocation and parallel degree. You can also enable logging and specify a name for the logfile other than the default name that is given.

4. Select the partitions that you want to include for synchronizing. You can also choose Select All or Select None (to clear all check boxes and start over).

5. Specify the parallel degree and memory options that you want for the partitions. Leaving parallel degree empty or at 0 turns off parallelism.

6. Click Submit.

   The Synchronize Confirmation page appears asking if you want to synchronize this Text index.

7. Click Yes to submit this job. Clicking No returns you to the Synchronize Text Index page.

To synchronize a non-partitioned Text index:

1. From the Text Indexes page, in the list of indexes, select the index that you want to synchronize.

2. From the list of available actions, select Synchronize.

3. Click Go.

   The Synchronize Text Index page appears. This page displays options depending on whether the index is partitioned or not. For non-partitioned indexes, you can specify memory allocation, parallel degree, timeout minutes, and lock behavior. You can also enable logging and specify a name for the logfile other than the default name that is given.

4. Specify the options that you want for this index.

5. Click Submit.

   The Synchronize Confirmation page appears asking if you want to synchronize this Text index.

6. Click Yes to submit this job. Clicking No returns you to the Synchronize Text Index page.