Intelligent SQL tuning without touching your source code
May. 15, 2018
Hong Kong, May 15, 2018 – 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 Pro (TSE Pro™), the major product of the Tosska SQL Tuning Expert Family of Products that provides state-of-the-art machine tuning capability to improve SQL performance for Oracle® without touching the source code.
SQL Tuning is a classical problem for every DBAs. Tuning SQL statements is finding the fastest route to execute the SQL statements. There have already been 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. The Tosska SQL Tuning Expert Product family aims to help DBAs to do SQL tuning just by multiple easy points and clicks.
“Tosska SQL Tuning Expert Pro is a tool for users to improve SQL performance without touching their program source code. Users can even deploy different performance query plans for various sizes of production databases without the effort of keeping multiple versions of the program source. It is especially suitable for package application users who don’t own the source code of their applications,” said KaMing Ng, CEO of Tosska. “If you are a packaged application user, how can you tune your SQL if you can’t edit a query directly? That’s why we decided to expand the TSE Product family and developed TSE Pro™ to solve this problem.”
“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 the only tool that can provide the most advanced Auto-Hints-Injection solution in the market to fully automate the process from SQL tuning to plan deployment,” said Richard To, CTO of Tosska. “TSE Pro™ also provides an intelligent workload-based index advisor 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 TSE Pro™ uses our proprietary Artificial Intelligent (AI) engine which can handle up to thousands of SQL statements and give you a reasonable recommendation that even human experts cannot achieve.”
Free Trial of TSE Pro™ is now available for 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.