With the batching framework in integration, we often check for updates from the ERP on a frequent basis and just pick up the deltas (changes since last time). This means that most syncs result in zero new records.
The Ecom provider can run an index, including a partial index. Partial index updates are efficient and have almost no overhead when no records change. However, there is some overhead to running even a partial index.
Would it be possible to have the index only run if there is at least one result in the import? If there are zero results, it shouldn't run the index.
Thanks,
Scott