ENABLE_CHECKPOINT

Use the ENABLE_CHECKPOINT procedure to enable the Checkpoint feature for a given Hierarchical Navigable Small World (HNSW) index user and HNSW index name.

Note:

  • This procedure only allows the index to create checkpoints. The checkpoint is created as part of the next HNSW graph refresh.

  • By default, HNSW checkpointing is enabled. If required, you can disable it using the DBMS_VECTOR.DISABLE_CHECKPOINT procedure.

Syntax

DBMS_VECTOR.ENABLE_CHECKPOINT('INDEX_USER',['INDEX_NAME']);

INDEX_USER

Specify the user name of the HNSW vector index owner.

INDEX_NAME

Specify the name of the HNSW vector index for which you want to enable the Checkpoint feature.

The INDEX_NAME clause is optional. If you do not specify the index name, then this procedure enables the Checkpoint feature for all HNSW vector indexes under the given user.

Examples

  • Using both the index name and index user:

    DBMS_VECTOR.ENABLE_CHECKPOINT('VECTOR_USER','VIDX1');

  • Using only the index user:

    DBMS_VECTOR.ENABLE_CHECKPOINT('VECTOR_USER');

Related Topics

Parent topic: DBMS_VECTOR