These are the steps and the tools shown in the image:
- Put plans into the PLAN table. ttOptSetFlag
- Prepare command. Connection.prepareStatement
- Examine PLAN table. SELECT * FROM SYS.PLAN
- Set various optimizer hints. ttOptSetFlag
- Prepare command again. Connection.prepareStatement
- Examine PLAN table. SELECT * FROM SYS.PLAN
Repeat steps beginning with "Set various optimizer hints" until plan is fully optimized.