​
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?

Partitioned IndexTokenizers