About Us

The ever changing database management challenges
With the rapid changes of modern databases, database administrators and developers have to learn and manage new features provided by databases with short period of time. There is always a time gap between fully mastering new features and actually implementing the new features in production.

Easy-to-use AI enabled tools for SQL & database performance tuning
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. Indeed 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.

Our Products

The Tosska SQL Tuning Expert Products Family – Not just another SQL Tuning tool !

Most SQL tuning products in the market aim to provide better query plan visualization, better statistics analysis, high cost query plan steps indication or even rule-of-thumb syntax recommendations. But very few of them can provide satisfactory tuning results directly. They require users to have in-depth SQL tuning knowledge to manually intervene the SQL tuning process amid their busy daily duties. In fact users are looking for one-button-solution tool that have all the required SQL tuning knowledge built-in and can tune a SQL statement automatically without the need of users’ intervention. If you are looking for such tools, these are the products you must look into !


Tosska SQL Tuning Expert (TSEM™) for MySQL®

There are not many SQL tuning tools for MySQL database. If you are eager to get a one-button-solution tool that can tune MySQL SQL statement automatically without the need of your intervention, then Tosska SQL Tuning Expert for MySQL may be your only choice. You can just sit back, relax, and wait for the best SQL alternative to come up on your screen.

World’s Leading A.I. SQL Rewrite technology for MySQL database
Tosska A.I. SQL Rewrite Engine is probably the world’s only A.I.-based machine SQL Rewrite solution for MySQL database. It not only saves developer’s time to rewrite a problematic SQL statement to make it faster, but also explores the potential best SQL syntax that even an experienced developer cannot discover. Tosska A.I. rewritten SQL syntax can also work with our Hints-injection algorithm to further explore more potential query plans that even most experienced developers cannot achieve.

A 100 times faster SQL rewrite is generated on the right hand side.

Tosska proprietary Tree Plan format for your easy understanding
Tosska SQL Tuning Expert (TSEM™) for MySQL® has a market leading explain plan function for MySQL. The proprietary Tree Plan format provides rich statistics information like what is provided by Tubular Explain from MySQL, as well as a hierarchical structure like what is displaying in visual plan. The beauty is that all such information can be displayed in a small window for easy reading.

Tosska Tree Plan

View Details | Free Download | Buy License

 
Tosska SQL Tuning Expert for Oracle® (TSE™ and TSE Pro™) version 4


Targeted for the Oracle database, Tosska SQL Tuning Expert (TSE™) for Oracle® and Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle® are complete SQL tuning solutions that provide SQL syntax rewrite, Query Hints injection and index recommendation to maximize the performance of a SQL without compromise in any specific feature’s limitation.
They give users the ultimate SQL performance solution by just point and click without the need of user’s involvement. What you have to do is to input your problematic SQL statement into the product and press a button. You don’t have to do analysis, guessing or testing during the entire SQL tuning process. The improved SQL statement will be benchmarked with your original SQL statement side by side without suspicion.

World’s Leading A.I. SQL Rewrite technology for Oracle database
Tosska’s 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 by exploring the potenial best SQL syntax and hints injection that even an experienced developer cannot discover.

Plan Control feature to tune your SQL even if you don’t have the source code
Tosska SQL Tuning Expert Pro (TSE Pro™) also comes with an innovative Plan Control function that improves your SQL performance without touching your 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. For application developers, 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.


Intelligent Workload-Based Index Advisor
Apart from the intelligent SQL tuning features, a powerful indexes recommendation function is also provided in TSE Pro™ to help users to review and explore more potential indexes that are helpful but may be missing in current database schema.

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.

Product feature comparison of TSE Pro™ and TSE™

View Details | Free Download – TSE™ / TSE Pro™ | Buy License – TSE™ / TSE Pro™

 

Tosska In-Memory Maestro (TIM™) for Oracle® automates the In-memory SQL optimization process and provide In-memory objects recommendations for a given SQL workload with our proprietary artificial intelligent engine.

Tosska In-memory Maestro (TIM™) also provides user friendly In-memory simulation function for user to virtually evaluate their in-memory table objects for one SQL or a given SQL workload captured from SGA or AWR without actually populating those table objects.





View Details | Download Free Trial | Buy License

Our Company

Tosska Technologies Limited is a young and energetic company that provides intelligent database tuning tools to help our customers to optimize their databases performance to the maximum within the current database and hardware limitation.

With the rapid changes of modern databases, database administrators and developers have to learn and manage new features provided by databases with short period of time, there is always a time gap between fully mastering new features and actually implementing the new features in production.

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 focuses on 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.

Tosska has a very strong technical team. Our CTO has over twenty year experiences in the Artificial Intelligent software development field supported by a development team with solid database management related software development experience in fortune 500 international corporations.

News


SQL statements or queries are designed to retrieve information from the database. A user can achieve the same results through optimization in SQL; using a tuned query is especially useful from an execution perspective. 

Tuning a database is a vital step in organizing and accessing the information in a database. Performance tuning in SQL requires streamlining and homogenizing the environment of a database and the files in it. This simplifies the way users access data in a big way. 

Why Companies Need to Consider Optimization in SQL

Several organizations own databases, but not all of them hire IT staff knowledgeable in the ways of optimization in SQL. Only professionals who have tuning skills and experience along with insider information about the working of databases should do this. 

In case your company has a database but it hasn’t undergone performance tuning, you might encounter inadequate responses to queries and face unnecessary complications when handling data. Don’t let your efficiency get affected because of something avoidable like this! 

Performance Tuning in SQL: What It Involves

Tasks related to performance tuning include optimization in SQL database, creating and managing indexes, and other related tasks to maintain or improve database performance. The goal of MySQL query optimization is to increase the speed and brevity of query responses and to simplify data retrieval. 

Let’s look at three major reasons why companies need to take performance tuning and seriously – 

1. To enhance the rate of data fetching options

If your database lacks optimization, then fetching data can get slower with increasing data loads. Optimizing queries enables users to create indexes and eradicate issues that may be slowing down data retrieval. After all, it can get quite frustrating for your employees to wait for the database to perform its operations, which can pass on to customers forced to wait for the same.

2. To refrain from coding loops

Making your database go through a coding loop is akin to hammering it repeatedly. That’s because the same query is executed several times when it is placed in a loop. However, once you remove the query from the loop, you will experience a definite surge in performance because the query is run only once rather than going through multiple iterations. 

3. To increase the performance of your SQL statements 

Query tuning in SQL includes changing previous query patterns and habits that were affecting the speed of data storage and retrieval. For example, the use of SELECT is reduced by opting for separate column declaration and eliminating correlated subqueries. Queries are also simplified by obviating temporary tables at times, aside from many other techniques of optimization in SQL

Your database will be able to manage much more data after the application of all these improvements as these will increase its efficiency, making it scalable as well. Once your database has scalability, it also overcomes lower performance and ensures user satisfaction in terms of experience. 
If you require professional tools to manage MySQL query optimization and tuning, then Tosska can help you. Tosska provides highly intuitive tools that can simplify query tuning beyond your imagination, and it does this with the help of innovative AI technologies. Contact us today to learn more about our range of query optimization products and services.

SQL performance tuning can be an extremely complicated task, especially where data in huge quantities is concerned. When implementing queries to insert data in large quantities, even the tiniest of changes can have a major impact on performance – for better or for worse. 

If you are new to databases, you may be wondering what SQL performance tuning is and how you can use it with sound knowledge of the fundamentals and a few tricks up your sleeve. In this blog, you will find some fundamental techniques for SQL tuning to improve performance of SQL query being entered in the database. 

Techniques to Improve the Performance of SQL Queries

Consider these five tips and techniques to enhance database performance – 

Indexing

Indexes are quite effective in SQL tuning but are often overlooked at the time of development. Basically, an index is a data structure that can boost data retrieval speeds in tables by supplying quick random lookups and prompt access to requested records. This implies that once you have made an index, selecting, SQL performance monitoring, and sorting operations are faster. 

They are also useful in defining a primary key that will prevent other columns from having the same values. Naturally, database indexing is a vast topic that deserves its own set of blogs, but for now, it is important to understand that the aim is to index the larger columns intended for searching and ordering.

  • Keep in mind, however, that indexes must be modified after INSERT, UPDATE, and DELETE operations, which means they could actually worsen the performance of the database if your tables are receiving a large number of these commands. 
  • Furthermore, Database Administrators usually discard their indexes before executing gigantic batch inserts involving millions of rows, to hasten the insertion process. Once the task is complete, they then create the indexes all over again. It is important to remember, in such cases, that when the indexes are dropped in this manner, it affects all the queries being executed in that table. Hence, to improve performance of SQL query, this approach is typically taken in certain situations that require a single sizable insertion.

Execution Plan Tool in SQL Server

This tool helps create indexes and it shows all the data retrieval techniques selected by the query optimizer. There are walkthroughs available that will help newcomers learn more about this tool.

  • If you are using the SQL Server Management Studio, you can fetch the execution plan by pressing on Ctrl+M to select the “Include Actual Execution Plan” option before executing your query. This leads to a third tab named “Execution Plan” that will show any missing indexes that it has detected.

Steer Clear of Coding Loops

Suppose you need to insert a thousand queries in your database in one go. In that case, you may be tempted to do it using a loop but you must, in fact, refrain from doing so. 

  • Instead, consider changing the snippets containing the loop in unique INSERT or UPDATE statements that have additional rows and values. 
  • Make sure that your WHERE clause avoids updating the stored value if it matches the existing value. Such a trivial optimization can dramatically improve performance of SQL query by updating only hundreds of rows instead of thousands.

Checking Whether a Record Exists 

This is a handy SQL optimization approach that concerns the use of EXISTS(). 

  • In case you want to know if a certain record is present in the database, make a preference for EXISTS() instead of COUNT(). That’s because EXISTS() can give you much better performance with more coherent code as it leaves the table the moment it gets the data it needs. On the other hand, COUNT() scans the whole table every single time, counting up each and every entry that matches your condition.

Click to view Tosska SQL Tuning Expert (TSE™) 4.0.0 Release Notes

Click to view Tosska SQL Tuning Expert Pro (TSE Pro™) 4.0.0 Release Notes

Tosska SQL Tuning Expert for MySQL

Click to view Tosska SQL Tuning Expert (TSEM™) for MySQL 2.1.0 Release Notes

Click to view Tosska SQL Tuning Expert (TSEM™) for MySQL 2.0.0 Release Notes

Click to view Tosska SQL Tuning Expert (TSE™) 3.2.0 Release Notes

Click to view Tosska SQL Tuning Expert Pro (TSE Pro™) 3.3.0 Release Notes

Click to view Tosska SQL Tuning Expert (TSEM™) for MySQL 1.1.0 Release Notes

Click to view Tosska SQL Tuning Expert Pro (TSE Pro™) 3.2.1 Release Notes