Automatic indexing in Jet Data Manager is designed to optimize performance by creating indexes for conditional lookups. However, in very large datasets, typically with several million records, the size and maintenance cost of these indexes can exceed their performance benefit. In such cases, you may want to disable automatic index creation and manage indexes manually.
How to Disable Automatic Indexing?
Follow these steps to turn off automatic index creation for a specific table:
1. Select the Table
Locate the table where you want to disable automatic indexes.
2. Review the Lookup Join Fields
In Jet Data Manager, check which fields are being used in the conditional lookup join.
3. Compare with SQL Indexes
Open the source table in SQL Server and examine existing indexes.
You’ll notice that an index has been automatically created for the join fields.
4. Edit the Conditional Lookup
Right-click the lookup field and select Edit Conditional Lookup.
5. Enable Manual Index Creation
Check the option labeled Manual index creation.
This stops Jet Data Manager from generating indexes automatically for this lookup.
6. Deploy and Execute
Deploy and execute:
The table containing the conditional lookup
The source table the lookup depends on
7. Verify the Index Removal
After execution, check the SQL source table again.
The automatically created index from Step 3 should now be removed.
👉 Join our Jet Analytics Training and master building data warehouses, cubes, and advanced dashboards.
Why Disable Automatic Indexing?
You may choose to turn off automatic index generation when:
Indexes become too large to maintain efficiently
Insert/update operations slow down due to index overhead
You want full manual control over indexing strategy
Existing SQL indexes already serve the required join conditions
Conclusion
Disabling automatic indexing gives you more control over performance, especially when working with very large datasets. By managing indexes manually, you can ensure that only the necessary indexes are created, reducing maintenance overhead and improving efficiency where needed in Jet Analytics.
