Description of the illustration execution_steps.gif

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

• Set various optimizer hints. ttOptSetFlag
• Prepare command. SQLPrepare
• Run command. SQLExecute
• Run command. SQLExecute
• Command is invalidated (if application chooses to invalidate). ttOptUpdateStats on T2
• Command is reprepared automatically, using same hints, and run. SQLExecute
• Run command. SQLExecute
• Drop command. SQLFreeStmt