Description of the illustration jdbc_exec_steps.gif

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

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