How to limit number of alternatives returned when using Auto Optimize SQL
Reduce the 'Search Depth' value (start at 1 and work up if you need more alternatives)
Check option 'Stop if optimization exceeds' and set minutes to your requirements. Default is 10 minutes
or
Use 'SQL Optimizer for Oracle' for more advanced features and flexibility
