Click to view Tosska SQL Tuning Expert (TSE™) 2.0.3 Release Notes
Why I can only see the first 20 alternatives after tuning of my SQL?
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.
Do I use elapsed time or response time as my SELECT statement tuning objective?
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.
What should I do if no better alternatives can be found for my SQL?
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.
Can I tune the SELECT portion only for an INSERT statement?
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.
How does TSE Pro™ different from TSE™ ?
Below are the Products Features Comparison between Tosska SQL Tuning Expert Pro (TSE Pro™) and Tosska SQL Tuning Expert (TSE™) :
| Modules | Tosska SQL Tuning Expert Pro (TSE Pro™) | Tosska SQL Tuning Expert (TSE™) |
| Tune SQL – Hints Injection | Yes | Yes |
| Tune SQL – Deploy Plan | Yes | No |
| Advise Indexes | Yes | No |
| Manage SQL Patches | Yes | No |
| Manage Plan Baselines | Yes | No |
Tosska SQL Tuning Expert (TSE™) 1.5.0 Release Notes
Tosska SQL Tuning Expert (TSE™) 1.1.2 Release Notes
Tosska SQL Tuning Expert (TSE™) 1.1.1 Release Notes
Tosska Technologies announces the availability of their flagship SQL performance tuning product – Tosska SQL Tuning Expert (TSE™) for Oracle®
An innovative machine tuning tool for SQL statements
Dec. 18, 2017
Hong Kong, December 18, 2017 – Tosska Technologies Limited (Tosska), an IT company that provides database and SQL performance related tools, today announces the general availability of Tosska SQL Tuning Expert (TSE™), their first product that provide machine tuning capability to improve SQL performance for Oracle®.
SQL Tuning is a classical problem for every DBAs. Tuning SQL statements is finding the fastest route to execute the SQL statements. In order to tune a SQL statement, you are required to know your database architecture and have in-depth knowledge of SQL tuning skill.
“There are a lot of SQL tuning tips in the market, but most of them are good only in specific database environment. You need to try those tips one by one manually on your databases. It is not only time-consuming, but there is also no guarantee that you will find the best performance solution for your SQL statements,” said KaMing Ng, CEO of Tosska. “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? That’s why we designed TSE to solve this problem.”
“The design concept behind TSE™ is to provide a machine tuning tool that optimizes SQL statements without the need of user’s involvement. Users just need to input their problematic SQL statements into the tool and press a button and then the tool will take care the rest. Users don’t have to do analysis, guessing or testing during the entire SQL tuning process,” said Richard To, CTO of Tosska. “TSE™ achieves this by using a proprietary technology with an embedded Artificial Intelligent (AI) engine 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.”
TSE™ is now available for free download from Tosska’s website. Please visit Tosska’s website www.tosska.com for details.
About Tosska
Tosska Technologies is a company that focuses in providing solutions for database and SQL related performance optimization and improvements. Our mission is to help users to smooth out the hurdle by our new technologies. Furthermore, Tosska is one of the very few companies in the world that focus in using artificial intelligence technology to solve various database performance problems. It is our goal to help our customers to reduce their hardware investment; increase their database applications service level and free up their human resources for more strategic activities with our innovative technologies. For more information visit www.tosska.com or email us at enquire@tosska.com.
Press and Media Inquiries
KaMing Ng
Chief Executive Officer
Tosska Technologies Limited
Phone: +852-28248420
Email: enquire@tosska.com
All Trademarks mentioned on this Site are the property of their respective owners.