Name
VT_BATCH_UPDATE — Set batch mode update of free text indexing.
Synopsis
integer DB.DBA.
VT_BATCH_UPDATE
(
|
in table varchar , |
| in flag varchar , | |
in
interval_minutes
integer
); |
Description
This function controls the time of update of a text index. If flag is ON, changes are accumulated into a change tracking table and applied as a batch. If flag is OFF, the text index is updated in the same transaction as the indexed data itself. The change tracking table is automatically created and is named VTLOG_<q>_<o>_<table>, in the qualifier and owner of the indexed table, where q, o and table are the qualifier, owner and name of the table. The changes accumulated into that table can be explicitly applied to the index using the VT_INC_INDEX_<q>_<o>_<table> function.
Parameters
table
the name of the table to perform batch updating of.
flag
If ON, updates are in batch mode, if OFF, they are synchronous.
interval_minutes
the update interval. NULL means that updates are not scheduled.
Errors
Table 24.115. Errors signalled by
| SQLState | Error Code | Error Text | Description |
|---|---|---|---|