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,073 of 44,300   
   Ed Prochak to trac...@gmail.com   
   Re: Introduce an innovative machine tuni   
   14 Dec 17 11:49:43   
   
   From: edprochak@gmail.com   
      
   On Tuesday, December 12, 2017 at 4:53:18 AM UTC-5, trac...@gmail.com wrote:   
   > 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:   
   > >   
   []   
   > > > 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 ....."   
      
   So it uses some heuristic algorithms.   
   Somehow it is better than an experienced DBA?   
      
   I'm not seeing the benefit.   
      Ed   
      
   --- 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