How much effort do I have to spend to tune a SQL?   
   There have been already 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. Tosska SQL Tuning Expert Pro is an innovative   
   product that can accept a bad performance SQL statement and give a better   
   solution just by users’ multiple easy points and clicks.   
   How much effort must I pay to implement the fix?   
   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.    
      
   How does our technology work?   
   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 every   
   database is unique and there    
   is no single rule which can improve a SQL across the broad.    
   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   
   limitation of their database    
   SQL optimizer. Therefore, they provide more than a hundred of Optimizer Hints   
   to help user 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,    
   developers 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.   
   https://tosska.com/tosska-sql-tuning-expert-pro-tse-pro-for-oracle/   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)