Description of the illustration jdbc_steps.gif

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.