...
The application enables the optimization of poorly-performing SQL code through the detection and modification of execution paths used in data retrieval. This This process is performed through the following functions:
...
For example, if tuning is selecting from two tables (A and B), it will enable the joining of A to B, or B to A as well as the join form. Additionally, different joining methods such as nested loops or hash joins can be used and will be tested, as appropriate.
Tuning will select selects alternate paths , and enable enables you to change the original path to one of the alternates. Execution paths slower than the original are eliminated, which enables you to select the quickest of the returned selections and improve query times, overall.
This enables the DBA to correctly optimize queries in the cases where the native optimizer failed.
| Scroll Ignore |
|---|
|
-ignore | true |
|---|
| scroll-office | true |
|---|
| scroll-chm | true |
|---|
| scroll-docbook | true |
|---|
| scroll-eclipsehelp | true |
|---|
| scroll-epub | true |
|---|
| scroll-html | true |
|---|
|
Automate SQL tuning and profiling with DB Optimizer. Learn more > > | IDERA Website | Products | Purchase | Support | Community | About Us | Resources | Legal
|---|