Tosska SQL Tuning Expert (TSE™) provides 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.
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.
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.
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.
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|
|Manage SQL Patches||Yes||No|
|Manage Plan Baselines||Yes||No|