- When possible to minimize metadata overhead
- When the table has many columns
- When the table has few rows
- Never, it is always better to use multiple transactions