Tosska SQL Tuning Expert for Oracle (TSE™) – Version 4
Intelligent SQL Tuning – beyond human wisdom
It is not another SQL Tuning tool
There have been already a lot of SQL tuning products in the market providing better query plan visualization, better statistics analysis, high cost query plan steps indication or even rule-of-thumb syntax recommendations. All in all, those tools are not helpful if users don’t have in-depth SQL tuning knowledge and are not willing to spend extra effort to tune a SQL apart from their daily duties. Users are eager for one-button-solution tool that can tune a SQL statement automatically without the need of users’ intervention. Tosska SQL Tuning Expert is an innovative product that can accept a bad performance SQL statement and give a better solution just by users’ multiple easy points and clicks.
Expensive SQL tuning effort by human expert
It may be up to days or weeks for a DBA or experienced SQL developer to tune a problematic SQL statement. SQL tuning is a very skillful job that not many developers are able to carry out in an enterprise. Should such expensive and valuable time be saved and used for other even more productive tasks inside a company?
What is Tosska SQL Tuning Expert for Oracle?
Tosska SQL Tuning Expert is a complete SQL tuning solution that provides SQL syntax rewrite, Query Hints injection and index recommendation to maximize the performance of a SQL without compromise in any specific feature’s limitation.
World’s Leading A.I. SQL Rewrite plus Hints Injection technology for Oracle database
Manually rewriting SQL syntax and query hints injection to tune a SQL statement is commonly adopted by experienced developers and DBAs, but the effort and cost to rewrite a SQL statement is quite expensive. It requires an in-depth SQL tuning knowledge developer to spend hours or even days to rewrite and test a problematic SQL statement, and the tuning result might not be the best among most of potential SQL rewrites due to the limitation of manual effort.
Tosska A.I. SQL Rewrite plus the A.I. Hints Injection Engine is the world’s leading machine SQL Tuning technology for Oracle database. It saves developer’s time to rewrite a problematic SQL statement by exploring the potential best SQL syntax and hints injection that even an experienced developer cannot discover.
More than 1000 times faster SQL rewrite is generated on the right hand side
On-the-job SQL training for in-house SQL developers
A SQL Query is used to retrieve data from your database. However, there may be multiple SQL queries that generate the same results but with different levels of efficiency. An inefficient query can drain the database resources, reduce the database speed or even result in a loss of service for other users. So it is very important to improve the in-house SQL developers with solid SQL writing skills. A short term SQL training course may be helpful, but it is not sustainable to resolve all daily SQL writing challenges. Tosska SQL Tuning Expert inbuilt SQL Rewrite Engine can help developers to correct minor mistakes and generate many semantically-equivalent SQL rewrites for user to compare with their original SQL syntax. Users can observe the SQL syntax, query plans, data distribution and SQL performance of those semantically-equivalent SQL to select the best SQL syntax to replace their original SQL statement. With the on-the-job SQL training process, it not only guarantees the good SQL quality produced during development cycle, but it also improves the in-house developers’ SQL writing skills through the process.
Uncompromised SQL index tuning for a SQL statement
For mission critical SQL statements, you may want to add indexes to the SQL to further optimize the statement to the ultimate performance without compromising the overhead of additional indexes. Tosska SQL Tuning Expert provides an A.I. index tuning power that tune your SQL by exploring the most effective potential new indexes.
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 |
