Indexing
Partial Index
Basic Usage
The following code block demonstrates how to pass predicates to create_bm25
to construct a partial index. Partial
indexes are useful for reducing index size on disk and improving update speeds over non-indexed rows.
CALL paradedb.create_bm25(
index_name => 'search_idx',
table_name => 'mock_items',
key_field => 'id',
text_fields => paradedb.field('description'),
predicates => 'category = ''Electronics'' AND rating > 2'
);
Was this page helpful?