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.

Oracle
Copyright © 1996, 2012, Oracle and/or its affiliates. All rights reserved.
Legal Notices