Description of the illustration jdbc_exec

These are the steps and the tools shown in the image:

Set various optimizer hints. ttoptSetFlag
Prepare command. Connection.prepareStatement
Execute command. Statement*.execute*
Execute command. Statement*.execute*
Command is invalidated (if application shooses to invalidate). ttopUpdateStats on T2
Command is reprepared automatically, using same hints, and executed. Statement*.execute*
Execute command. Statement*.execute*
Drop command. PreparedStatement.close