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.
Bring the automatic SQL tuning technology to new heights
With almost doubled the number of hints supported in version 2, Tosska SQL Tuning Expert Pro (TSE Pro) V2 SQL tuning ability is brought to new heights. It creates a new standard of Hints-injection-based SQL tuning ability that no other tools can achieve in the market. More problematic SQL can be improved with the new Hints and bigger Quota allocation of each Intelligent Level in TSE Pro version 2. The actual test result shows that even very simple SQL statements still have chance to be improved in various environments.
Options Window shows new Quota and Hints setting
Streamline from problematic SQL identification to optimization
A new Tune Top SQLs module is added to TSE Pro version 2, it is a powerful tool that can help user to extract high workload SQL statements from SGA and AWR into a Top SQL Repository and store in local PC. It is a very useful function for DBA to identify problematic SQL statements without the need of going through thousands of lines in program source codes. The layout of the captured SQL statements can be ordered by various resource consumptions, users can easily review and locate problematic SQL statements and prioritize them for later SQL tuning exercise. Each identified problematic SQL statement can be tuned by just a point and click in the Top SQL Repository window, and it is tightly integrated with the Tune SQL function to streamline the flow from problematic SQL identification to SQL optimization. Each tuned SQL will be recorded with improvement statistics and tuned SQL hints solutions. Users can also make any remarks on specific SQL statement as a reminder for follow-up actions.
SQL statements are captured from SGA and to be tuned one by one according to user’s priority
Specific SQL’s tuning details can be shown right next to SQL list tag page
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.
You should capture the most representative SQL workload that created performance problem in your system. For example, if there was a performance problem at 11:00 AM yesterday, you should extract this SQL workload from AWR for index recommendation.
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.
Yes, you can turn on SQL Plan Baselines in Deploy Plan page in Options window, but we recommend using SQL Patches without the SQL Plan Baselines’ hints application’s limitations.
You can evaluate the efficiency of the recommended indexes to your SQL workload to select most effective indexes for your database, but we recommend you to decrease the size of “Maximum number of recommended indexes” to let our AI engine to recommend a new set of indexes with less number of indexes.
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.
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 Pro 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.
Developers are used to tuning SQL statements by rewriting or applying hints to the SQL text to influence database SQL optimizer to generate a better query plan for the SQL statement. A tuned SQL statement must be placed back to the program source and necessary testing has to be carried out before software deployment. It is a time-consuming and error-prone process. With Tosska SQL tuning technology, users can streamline their SQL tuning process in one product without the need to touch their programs’ source code. Our Automatic Hints Injection process will help user to find potential better query plans. The speed of original SQL statement will be improved automatically after deploying the SQL Patch with the original SQL text. Oracle SQL optimizer will use the new plan of the deployed SQL patch next time while receiving the same SQL statement. Therefore, users do not have to modify their program sources to solve the SQL performance problems.