Generating an index with joins disabled

By default, the partition key fields are combined into a single field, _partitionKey, and stored as a string field to support joins between indexes. When join is not required, create an index with join disabled.

To disable joins after an index has been created, see Configuring search index joins.

Procedure

Create a search index with join disabled:

The PROFILES spaceSavingNoJoin option disables joins when creating a search index. For example:
```
CREATE SEARCH INDEX ON demo.health_data
WITH PROFILES spaceSavingNoJoin;
```

Verify that joins are disabled:

DESCRIBE ACTIVE SEARCH INDEX SCHEMA ON demo.health_data ;

...
<field docValues="false" indexed="false" multiValued="false" name="_partitionKey" omitNorms="true" stored="false" type="StrField"/>
...

Generating an index with joins disabled

Procedure

Was this helpful?

Give Feedback