The transformation is expressible in pure SQL (no procedural logic) - The affected row count is under ~500,000 - You don't need row-level error handling - Lock duration is acceptable (set-based holds locks until the statement completes)