v.24.12New Feature
Implement SYSTEM LOAD PRIMARY KEY Command for Efficient Index Loading
Implement SYSTEM LOAD PRIMARY KEY command to load primary indexes for all parts of a specified table or for all tables if no table is specified. This will be useful for benchmarks and to prevent extra latency during query execution. #66252 #67733 (ZAWA_ll).Why it matters
This feature aims to reduce query latency and improve benchmark accuracy by preloading primary key indexes, thus preventing delays caused by on-demand index loading during query execution.How to use it
Users can execute the commandSYSTEM LOAD PRIMARY KEY [table_name] to load primary key indexes for a specific table. Omitting the table name will load primary key indexes for all tables in the database.