Vertica Quick Tip: Which rows will commit?

Moderator: NorbertKrupa

Post Reply
User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Vertica Quick Tip: Which rows will commit?

Post by JimKnicely » Fri Jan 26, 2018 2:24 pm

Vertica Community Blog post authored by Jim Knicely
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
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica Links”