Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

DB Optimizer's SQL tuner will take a query and try to produce as many execution paths as possible. These alternative execution paths can then be run to see if there is a faster or less resource expensive execution path. The execution of each alternative case is timed and if the execution exceeds 1.5 X the original case then its execution is stopped and we move on to the next case. This avoids wasting time and resources on execution plans that are clearly sub-optimal.


Scroll pdf ignore
Automate SQL tuning and profiling with DB Optimizer. Learn more > >