REMOVE_AUTO_OPTIMIZE

Removes an index or partition from the list of indexes subject to auto optimization. No new auto optimization calls are made to this index. The removal takes effect immediately.

If the specified index is not in the existing list of indexes, then an error occurs. For partitioned indexes, an error occurs when the partition name is not specified.

Syntax

CTX_DDL.REMOVE_AUTO_OPTIMIZE(

    idx_name       IN VARCHAR2,
    part_name      IN VARCHAR2 default NULL
);

idx_name

Specify the name of the index to remove.

part_name

Specify the name of the partition to remove.

Related Topic

“ADD_AUTO_OPTIMIZE”