This command changes the characteristics of an index after the database has been enabled.
To changes the default settings that are used when a database is first enabled, use CHANGE TEXT CONFIGURATION.
Authorization
You must have at least one of the following for the table:
ALTER privilege
SELECT privilege
UPDATE privilege.
Command syntax
>>-CHANGE INDEX SETTINGS--table-name----------------------------> >-----+-----------------------------+---------------------------> '-HANDLE--handle-column-name--' >-----+----------------------------------------+--------------->< '-UPDATEFREQ--+-NONE------------------+--' '-| update-frequency |--' update-frequency |---MIN--(--mindocs--)--D---(--+-*------------+---)---H---------> | .-,-------. | | V | | '----0...6---+-' .-,---------. V | >----(--+-*-------------+---)---M---(-----0...59---+---)--------| | .-,--------. | | V | | '----0...23---+-'
Command parameters
If, however, the index was created using the command ENABLE TEXT TABLE, that is, the table has one text index for all text columns, then this keyword is ignored.
The syntax is described in Setting the frequency of index updates.
If you do not specify the UPDATEFREQ keyword, the frequency settings are left unchanged.