How to Disable Automatic Indexing for Data Loads

Available from version 9.3

Sometimes, a Data Load on a target, usually a Datamart, is scheduled to run very frequently.

Also, several Data Loads with the same target could run in sequence (refresh, enrichment, etc.). In these cases it would be useful to disable the automatic Index Maintenance job scheduling and schedule it manually at the end of the sequence.

To disable automatic indexing job scheduling, add the "disableAutoIndexing": true flag to the Data Load JSON definition (see below).

disableAutoIndexing is a property of a Data Load (DL) that controls whether an automatic IndexMaintenance job is scheduled at the end of a DL execution.

When disableAutoIndexing is true, the IndexMaintenance DL is not automatically scheduled after the Data Load. This allows for more control over when indexing occurs, which can be useful when running multiple DLs sequentially (e.g., refresh, enrichment) or when indexing needs to be scheduled at a specific time (e.g., nightly or weekly).
When disableAutoIndexing is false (default), an IndexMaintenance job is scheduled immediately after each Data Load, ensuring indexes are updated automatically.

Using this property requires integration or orchestration to explicitly schedule indexing at an appropriate time to maintain query performance and avoid potential locking issues.

Option 1: Via Partition Directly Editing The JSON File In The DL Section

Option 2: Via Intellj Idea Deploying The Changes On The Partition