Discover Top Posts Tagged with #update sql statement

5 More DB2 SQL Performance Tips

START Analytics Career

SELECT from INSERT, UPDATE whenever possible. This feature is great for getting the values associated with identity, sequence, and any other database column keys while doing an INSERT or UPDATE SQL operation. This capability provides for the capturing of generated key values needed to be returned to the application during an UPDATE or INSERT statement. Instead of executing…