set_col_searchable

Type of operation: Metadata

Description

Include or exclude columns from any future full-text search operation.

By default a full-text operation such as filter searches in all columns. set_col_searchable can be used to improve search performance by excluding columns that do not need to be searched.

Arguments are colname:bool where the bool value must be a literal true or false (default true).

Usage

set_col_searchable col_1, col_2, ...

Argument

Type

Optional

Repeatable

Restrictions

col

expression

no

yes

none

Accelerable

set_col_searchable is always accelerable if the input is accelerable. A dataset that only uses accelerable verbs can be accelerated, making queries on the dataset respond faster.

Examples

set_col_searchable cluster_uid:false, cluster_index:false

Exclude columns cluster_uid and cluster_index from future full text searches. For instance, a further filter operation filter * ~ error will not search error in these two columns.