VECSYS.VECTOR$INDEX$CHECKPOINTS

This catalog table provides detailed information about Hierarchical Navigable Small World (HNSW) full checkpoints at the database level. This table is not available when using Autonomous AI Database Serverless (ADB-S) or Dedicated (ADB-D). Oracle recommends using the fixed view, V$VECTOR_GRAPH_INDEX_CHKPT, instead.

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.