Generating an index with joins disabled

Disable index joins when not required to save space.

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.

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

Procedure

  1. 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;
  2. 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"/>
    ...