Index Automation in Jet Data Manager helps you automatically design, manage, and optimize indexes across your project. It ensures your data warehouse performs efficiently by generating the indexes needed for table relationships, lookups, selection rules and partitioning fields.
What Index Automation Considers
When determining which indexes to generate, Jet Data Manager evaluates:
Relationships between tables marked as Error or Warning
Joins on conditional lookup fields
Primary Key fields on Raw Tables
Selection Rules and Incremental Selection Rules on the Data Warehouse
Partitioning fields such as
DW_PartitionkeyandDW_TimeStamp
These criteria help JDM build indexes that improve query speed and overall data model performance.
Index Automation Modes
Index Automation can be enabled during project creation or updated later through the Edit Project settings. You can choose from three modes:
1. Automatic (Always On)
This mode continuously updates indexes whenever you make project changes that require new or modified indexing. No manual intervention is needed.
2. Manual (Per Request)
Indexes are only generated when you trigger Index Automation for an individual table.
You can do this by right-clicking the table and selecting the Index Automation option or using the Index Node.
3. Disabled
In this mode, Jet Data Manager only creates indexes during Data Cleansing Procedures and only when necessary. No proactive indexing occurs.
Setting Index Behavior for Individual Tables
While all tables inherit the project-level Index Automation mode by default, you can customize it per table:
Right-click the table
Go to Advanced > Advanced Settings
Modify the Index Generation Behavior
This allows greater control over performance optimization at the table level.
👉 Join our Jet Analytics Training and master building data warehouses, cubes, and advanced dashboards.
How Indexes Are Created
Indexes generated automatically follow the naming convention:
JDM aims to minimize the total number of indexes by combining lookups when possible. If multiple lookups can use the same index, the system reuses it instead of creating duplicates.
Jet Data Manager also respects your manually created indexes; using them when applicable without modifying or replacing them.
Conclusion
Index Automation is a powerful feature that reduces manual work and ensures consistent indexing throughout your project. Whether you choose automatic, manual, or disabled mode, you have full control over how indexes are created and optimized for your data warehouse.
