Click to view Tosska SQL Tuning Expert (TSE™) 3.2.0 Release Notes
Tosska SQL Tuning Expert (TSE™) 3.2.0 Release Notes
Tosska SQL Tuning Expert (TSE™) 3.1.0 Release Notes
Tosska SQL Tuning Expert (TSE™) 3.0.1 Release Notes
Tosska SQL Tuning Expert (TSE™) 2.0.3 Release Notes
Why I can only see the first 20 alternatives after tuning of my SQL?
Tosska SQL Tuning Expert product series provide the first 20 alternatives for free if you don’t have a license. If you are satisfied with our product’s functionality, you should purchase a license from our website to enjoy the full power of our product.
Do I use elapsed time or response time as my SELECT statement tuning objective?
Best elapsed time as the tuning objective for SELECT statement is normally useful for most situations, but for some online screens for many records display, good response time is very important for user experience. So, you should consider using response time as the tuning objective for this kind of applications.
What should I do if no better alternatives can be found for my SQL?
If you cannot find better alternatives at the current Intelligent Level, you can increase the Intelligent Level or disable the “Disregard SQL alternatives with cost > 50 times of Original SQL” to try more Hints permutation for your SQL statement.
Can I tune the SELECT portion only for an INSERT statement?
No, the SELECT portion’s execution plan may be different when it is executed with the INSERT operation. We recommend to tune whole INSERT statement without splitting it into pieces.
How does TSE Pro™ different from TSE™ ?
Below are the Products Features Comparison between Tosska SQL Tuning Expert Pro (TSE Pro™) and Tosska SQL Tuning Expert (TSE™) :
| Modules | Tosska SQL Tuning Expert Pro (TSE Pro™) | Tosska SQL Tuning Expert (TSE™) |
| Tune SQL – Hints Injection | Yes | Yes |
| Tune SQL – Deploy Plan | Yes | No |
| Advise Indexes | Yes | No |
| Manage SQL Patches | Yes | No |
| Manage Plan Baselines | Yes | No |
Tosska SQL Tuning Expert (TSE™) 1.5.0 Release Notes