Tosska SQL Tuning Expert Pro for Oracle (TSE Pro™)
– 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.
Intelligent Workload-Based Index Advisor
It is an intelligent and cost-aware index advice engine that helps users to review their existing database schema if there are any new indexes which can help to improve a given SQL workload. The engine can handle up to thousands of SQL statements and give you a reasonable recommendation that even human experts cannot achieve. Users can review those new indexes and the affected SQL statements side by side. Furthermore, the SQL statement’s workload is also catered during indexes advice processing, a SQL executed many times will be weighted higher to match its daily workload contribution. The indexes advice results are listed from using fewer indexes to more indexes, users can select the cost-effective indexes recommendation without incurring too much overhead to their databases.
Plan Control feature help you to tune your SQL even if you don’t have the source code.
Tosska SQL Tuning Expert Pro also comes with an innovative Plan Control function that improves your SQL performance without touching your program source code. It is especially suitable for package application users who don’t own the source code. For application developers, SQL tuning becomes easier than ever before, as a problematic SQL statement can be improved without going through the time-consuming unit test, integration test and program implementation required in software development cycle.
How to tune SQL when you can’t edit the source code?
What would you do with the following scenarios? If you are a package application user, how you can tune your SQL if you can’t edit a query directly? Or, if you are an application developer, what would do if you want to have a quick fix on SQL performance but without the time to go through source code change and unit test? There are multiple features provided by Oracle such SQL Profiles, SQL Plan Baselines and SQL patch that you can use to tell Oracle to fix a SQL’s query plan. But the use of these features is limited by Hints injection only, you cannot rewrite a SQL with different syntax and ask the original SQL to accept a rewritten SQL’s query plan. So, hints-based SQL tuning is becoming more important than ever before. Tosska SQL Tuning Expert Pro is probably the only tool that can provide advanced Auto-Hints-Injection solution in the market to fully automate the process from SQL tuning to plan deployment.
Ad-hoc SQL tuning becomes easier
Some SQL statements may be executed with sudden high volume of data periodically such as month-end or year-end processes. If Oracle database optimizer cannot generate a good plan immediately, the process may be prolonged and the business be affected. So, preventative measurement should be carried out before the SQL statements are executed, better query plans controlled by SQL patches for those SQL statements should be deployed/enabled before starting the processes. Users can disable/drop those SQL patches after the processes are finished and resume those query plans back to the normal status for better daily operations.
Product feature comparison of TSE Pro™ and TSE™