Did you ever update a bunch of rows in a table, then forget which ones you changed? Fearing you might have updated an incorrect record, you might have to roll back and start again. Or, in Vertica you can first check which records have been modified prior to executing a COMMIT statement!
Read more here:
https://forum.vertica.com/discussion/23 ... ill-commit