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