On Monday, December 11, 2017 at 5:42:24 PM UTC+8, Noons wrote:   
   > On 11/12/2017 4:10 @wiz, tracyto41@gmail.com wrote:   
   >   
   >   
   > > The machine tuning for SQL statements is a proprietary technology invented   
   by Tosska to mimic a human expert SQL tuning process, in which the engine   
   tries every possible Oracle Hints combinations for a SQL statement to improve   
   the execution speed.   
   >   
   > No human expert uses a brute force approach.  And if all it does is   
   > "mimic", then it is not a "proprietary technology", or is it?   
   > :)   
   >   
   > > As the permutation of Oracle Hints combinations to a SQL statement is so   
   huge, it is impossible for a human expert to accomplish it for complex SQL   
   statements.   
   >   
   >   
   > Er...  Human experts would only select the most likely combinations   
   > rather than use a brute force approach?   
   > But I don't want to brute force you into human expertise...   
   >   
   >   
   > > Furthermore, it is also no way for a DBA or developer to guarantee that   
   the best solution is found after a lot of trials and errors.   
   >   
   > Bingo!  See?  :)))   
      
   there are more than 100 hints from Oracle, if you pick 3 out from the 100   
   hints, the permutations is up to 1 million. No brute force can do it in your   
   database.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)