Sparse lookup is used when reference data DOES change frequently - it performs a direct database lookup each time rather than caching, which is expensive but necessary for dynamic data. For stable/infrequently changing data, you would use a cached lookup (not sparse) for better performance.