Tosska SQL Tuning Expert (TSE™) for Oracle®

An innovative machine tuning tool for SQL statementsTosska SQL Tuning Expert (TSE™) is a SQL tuning tool that optimizes your SQL statements without the need of user’s involvement. The product will give you the ultimate SQL performance solution by just point and click. What you have to do is to input your problematic SQL statement into the product and press a button.

You don’t have to do analysis, guessing or testing during the entire SQL tuning process. The improved SQL statement will be benchmarked with your original SQL statement side by side without suspicion.

The machine tuning for SQL statements is a proprietary technology invented by Tosska to mimic a human expert SQL tuning process, in which the engine tries every possible effective Oracle Hints combinations for a SQL statement to improve the execution speed within the given quota. As the permutation of Oracle Hints combinations to a SQL statement is so huge, it is impossible for a human expert to accomplish it for complex SQL statements. Furthermore, it is also no way for a DBA or developer to guarantee that the best solution is found after a lot of trials and errors.

Best solution without trial and errorWith Tosska SQL Tuning Expert (TSE™), users no longer need to rewrite or try every possible hints combination manually to the SQL statement to explore potential better performance execution plans, since all those hard tasks are released by the embedded Artificial Intelligence (AI) engine. Our intelligent engine will help you to find every possible Hints combination to improve your SQL speed without the need of your intervention. You just sit back, relax, and wait for the best SQL alternative to come up on your screen.

Provide even better than a human expert’s solutionTuning SQL is a time consuming job that requires in-depth knowledge on SQL tuning skill and most SQL developers are not trained to accomplish this job apart from their daily development tasks. Furthermore, there is no way for a DBA to explore all alternative execution plans within a short time. The following screenshot shows that Tosska SQL Tuning Expert can explore thousands of SQL alternatives in just a few minutes that may require a human expert months’ effort to do.
After the benchmarking partial or all SQL alternative execution plans, the best SQL alternative will be displayed with Original SQL statement side by side on the screen. The process is fully automatic without the need of user’s involvement and the result is the best out of thousands of potential execution plans that Oracle can generate for this SQL statement. This exhaustive search and test process is impossible to be accomplished by a human expert.

Uncompromised SQL tuning solution within manageable timeIt is known that the longer you spend on the SQL tuning process, the more chance you may get a better SQL alternative. It is also true in Tosska SQL Tuning Expert that the user can adjust the Intelligent Level to control the time to spend on a specific SQL statement according to the complexity of your SQL statement. For complex SQL statements with huge potential execution plans, user can allocate more resource and time to explore the ultimate performance solution for the SQL.

The predefined intelligent level is 5 sets of “Preselected Hints” and “Maximum number of SQL to investigate” setting to control the size of search space. The larger the search space, the more chance the engine can find a better SQL solution for a problematic SQL statement.
The “User Define” option is also available to experienced users to tackle complicated SQL performance problems with manual specification of hints and maximum number of SQL to investigate during the tuning process.

To learn more how it works, watch the simple introductory video below.