home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle.server      Oracle Sysadmins question their careers      44,300 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 43,069 of 44,300   
   Noons to tracyto41@gmail.com   
   Re: Introduce an innovative machine tuni   
   11 Dec 17 20:42:11   
   
   From: wizofoz2k@yahoo.com.au   
      
   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?  :)))   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca