Optomizer spoeed very slow with

I’ve started this exact SQL before, but was asked to stop due to the load on ther database. It had over 50 alturnatives timed in 3 hours; with the latest version of TOAD only 19 alturnatives timed in 3 hours.

I’m assuming a database glitch and will restart the job…

Slow tuning_12.9.0.60.docx (147 KB)

I tried on .61 version (last one) and works OK.

If you still have some problems that I would advise you to start trace to see where the time is lost…

Thank you Damir! It was a one time glitch.