首批通过分布式安全可靠测评，为关键业务系统打造
COMPACT_INDEX
更新时间：2026-06-24 20:57:51
编辑
分享
COMPACT_INDEX 过程用于手动强制触发合并任务，对应 HNSW 向量索引中增量段之间或与基线段合并的流程。原理说明请参见 向量索引原理。
语法
PROCEDURE COMPACT_INDEX(
IN TABLE_NAME VARCHAR(65535),
IN IDX_NAME VARCHAR(65535)
);
参数说明
| 参数 | 描述 |
|---|---|
| table_name | 表名。 |
| idx_name | 索引名。 |
示例
创建测试表。
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.COMPACT_INDEX('vector_index_test', 'idx1');
