How does TSE Pro™ work and what technology does it use?

Tosska SQL tuning uses our proprietary Auto-Hints-Injection technology to highly explore a given SQL statement’s potential execution plans that the Oracle SQL optimizer cannot archive within a limited timeframe. Furthermore, our technology is not limited by unreliable cost estimation algorithm, blinding SQL syntax restructure or any misleading human rule-of-thumb assumptions, since all those methods may not be valid in various database environments. We believe that every database is unique and there is no single rule which can improve a SQL across the board.

Although Oracle has the most sophisticated SQL optimizer, there are no guarantees that all SQL statements can be running up to the users’ expected performance. It is just like other databases in the market; Oracle knows the limitations of their database SQL optimizer. Therefore, they provide more than a hundred of Optimizer Hints to help users to tune bad performance SQL statements manually. To effective use those hints to tune a SQL statement is a difficult task even for experienced SQL developers, as they have to understand the SQL’s execution plan, SQL syntax and how those applied hints are affecting the execution plan generated by Oracle SQL optimizer. There are not many experts in the market that can master this technique to compose compatible Hints and create SQL Patches for complex SQL statements.

Tosska SQL Tuning Expert Pro is the only powerful tool that can automatically compose Hints and create SQL Patches to optimize a SQL statement without touching your program source code. The optimization solutions provided by the product normally can outperform most of human experts in the market.