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.

Note: In Oracle Database Release 21c, the procedures ADD_AUTO_OPTIMIZE and REMOVE_AUTO_OPTIMIZE, and the views CTX_AUTO_OPTIMIZE_INDEXES, CTX_USER_AUTO_OPTIMIZE_INDEXES and CTX_AUTO_OPTIMIZE_STATUS are deprecated.

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”