跳到主要内容
版本：V1.0.0

REFRESH_INDEX

REFRESH_INDEX 过程用于增量刷新向量索引。

语法​

PROCEDURE refresh_index(
    IN     idx_name               VARCHAR(65535),               
    IN     table_name             VARCHAR(65535),                
    IN     idx_vector_col         VARCHAR(65535) DEFAULT NULL,   
    IN     refresh_threshold      INT DEFAULT 10000,             
    IN     refresh_type           VARCHAR(65535) DEFAULT NULL);

参数说明​

参数描述
idx_name索引名。
table_name表名。
idx_vector_col向量列名。
refresh_threshold增量数据数量。
refresh_type刷新类型。可选值为 FAST。

示例​

创建测试表。

CREATE TABLE vector_index_test(c1 INT, c2 VECTOR(3), PRIMARY KEY(c1), VECTOR INDEX idx1(c2) WITH (distance=l2, type=hnsw, lib=vsag));

写入测试数据。

INSERT INTO vector_index_test VALUES(1, '[0.203846,0.205289,0.880265]');
INSERT INTO vector_index_test VALUES(2, '[0.484526,0.669954,0.986755]');
INSERT INTO vector_index_test VALUES(3, '[0.327936,0.048756,0.084670]');
INSERT INTO vector_index_test VALUES(4, '[0.148869,0.878546,0.028024]');
INSERT INTO vector_index_test VALUES(5, '[0.334970,0.857377,0.886132]');
INSERT INTO vector_index_test VALUES(6, '[0.117582,0.302352,0.471198]');
INSERT INTO vector_index_test VALUES(7, '[0.551185,0.231134,0.075354]');
INSERT INTO vector_index_test VALUES(8, '[0.185221,0.315131,0.558301]');
INSERT INTO vector_index_test VALUES(9, '[0.928764,0.254038,0.272721]');

触发更新。

-- 触发增量更新。
CALL DBMS_VECTOR.REFRESH_INDEX('idx1', 'vector_index_test', 'c2', 1, 'FAST');

相关文档​

Contents

编辑此页