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.
Create a search index with join disabled:
PROFILES spaceSavingNoJoinoption 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"/> ...