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,070 of 44,300   
   tracyto41@gmail.com to Noons   
   Re: Introduce an innovative machine tuni   
   12 Dec 17 01:53:10   
   
   On Tuesday, December 12, 2017 at 5:46:08 PM UTC+8, Noons wrote:   
   > On 12/12/2017 8:36 @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.   
   > >>   
   > >   
   > > 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.   
   > >   
   >   
   >   
   > Precisely.   So why advertise that Tosska crap as a product that can do   
   > it?   Unless of course this:   
   >   
   > "in which the engine tries every possible Oracle Hints combinations for   
   > a SQL statement to improve the execution speed"   
   >   
   > doesn't now mean a brute force approach?   
      
   Yes, you are right. It should be   
      
   "in which the engine tries every possible effective Oracle Hints combinations   
   for ....."   
      
   --- 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