For some reason, I just can’t figure out when I get hundreds of scenarios
returned (defaulted to checked) in sql optimizer, how one would unselect all of
them so I can then pick and choose the ones I wish to run. I know I can cut down
the intelligence but I still don’t have a clear understanding of how to utilize
that and what the best number settings would be. Currently I have Optimization
Intelligence at Level 5 and Index Expert Intelligence Level at 0.
I have tried multi selecting and then right clicking which intuitively would be
where I would think I find this option but no avail.
I am running Prod Version 18.104.22.1688 from Toad for Oracle Xpert version 22.214.171.124
against 11g Oracle db.
Any guidance would be appreciated.