VECSYS.VECTOR$INDEX$CHECKPOINTS

This dictionary table provides detailed information about Hierarchical Navigable Small World (HNSW) full checkpoints at the database level.

Column Name Data Type Description

INDEX_OBJN

NUMBER

The index object number to uniquely identify the HNSW index.

INDEX_OWNER_ID

NUMBER

The owner id for the vector index.

CHECKPOINT_ID

NUMBER

A monotonically increasing ID tracking various checkpoints for this HNSW index.

CHECKPOINT_SCN

NUMBER

The SCN as of which the HNSW checkpoint is taken.

CHECKPOINT_TYPE

NUMBER

Full Checkpoint is the only checkpoint type supported.

VERSION_NUMBER

NUMBER

The checkpoint format may change in between releases. Thus, you can use a version number to decide whether to reload the HNSW index using a particular checkpoint.

TABLESPACE_NUMBER

NUMBER

The tablespace number. You can view a tablespace number to decide whether to store full checkpoints of your HNSW graphs in the same tablespace or in a different one.