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.
Alternative Wisdom