REFRESH INVERTED INDEX

TiDB Cloud Lake 会在写入新数据时自动刷新 SYNC 模式的倒排索引。REFRESH INVERTED INDEX 主要用于回填在声明索引之前已存在的行。

语法

REFRESH INVERTED INDEX <index> ON [<database>.]<table> [LIMIT <limit>]

示例

-- Existing table with data loaded before the index was declared
CREATE TABLE IF NOT EXISTS customer_feedback(id INT, body STRING);
INSERT INTO customer_feedback VALUES
  (1, 'Great coffee beans'),
  (2, 'Needs fresh roasting');

-- Create the inverted index afterward
CREATE INVERTED INDEX customer_feedback_idx ON customer_feedback(body);

-- Backfill historical rows so the index covers earlier inserts
REFRESH INVERTED INDEX customer_feedback_idx ON customer_feedback;

-- Future inserts refresh automatically in SYNC mode