A delta index is activated when the main index grows too large (100K-1M documents) OR exceeds a specific size threshold. 500MB is a common threshold that balances search performance against index rebuild overhead. Larger thresholds like 1-2GB would cause performance degradation before delta activation.