Tosska 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 error
With 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 solution
Tuning 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 time
It 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 “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.
Before installing Tosska SQL Tuning Expert (TSE™) for Oracle®, please make sure your system meets the following minimum hardware and software requirements:
|CPU||1.8 GHz Processor|
|Memory||2 GB of RAM minimum, 4 GB of RAM recommended|
|Hard Disk Space||200 MB of disk space for 32-bit installation
400 MB of disk space for 64-bit installation
|Operating System||Microsoft Windows® 7 32-bit and 64-bit
Microsoft Windows® 10 32-bit and 64-bit
|.NET Framework||Microsoft .NET Framework 4.5|
|Database Client||Oracle® 9i Client
Oracle® 10G Client
Oracle® 11G Client
Oracle® 12c Client
Oracle® client is not required when Basic Type is used for Connection Mode
|Database Server||Oracle® database 11G, 12C|